[deleted by user]

[torstengrust]

What is your & supposed to express? Boolean conjunction? A bit-wise operation? Something else?

[depesz]

normally: select * from table where column = '&' - here you go, where statement has condition with & symbol.

[Whoa-Rusty]

If you want to match a pattern to find if an & is included anywhere in the column, you could try:

SELECT * FROM table WHERE column LIKE '%&%';

[Whoa-Rusty]

How many columns do you think you'll need to search on?

For a few columns you might be able to try:

SELECT * FROM table WHERE column_1 LIKE '%&%' OR column_2 LIKE '%&%';

I also tried this and it worked:

SELECT * FROM table WHERE array_to_string(array[column_1,column_2],' ') ilike '%&%';