在 sql 中以管道分隔的列中的搜索值

我想搜索列中以管道分隔的值.见下文.

I want to search value which is pipe-separated in column. See below.

Column1 
1
1|2|23
2
6
6|12

我想在所有行中搜索 2，这样它就会返回到行下方

I want to search 2 in all rows so it will return below rows

Column1
1|2|23
2

谁能告诉我我们怎样才能做到这一点?

Can anyone please tell me how can we achieve this?

你可以使用like:

where '|'+column1+'|' like '%|2|%'

通过包含额外的分隔符，您可以避免2"匹配23".

By including the extra delimiters, you avoid having "2" match "23".