How do I search underscore character in a given column?

Answer 1

You need to escape the underscore, to treat it as a character and not a search wildcard.

SELECT column FROM table WHERE column LIKE '%\_%' ESCAPE '\';

Answer 2

Thanks

Answer 3

Or with regular expression in the where clause, e.g.:
select *
from table
where column_name REGEXP '.*\_.*';