How to search the underscore in a column for SQL?

How to search for the underscore in a column for SQL?

I tried:

select * from xxx where xxx like '%_%';
and
select * from xxx where xxx like '%$_%';

But that doesn’t work as expected. How do I escape underscore in SQL LIKE Operator?

>Solution :

Try this:

SELECT * FROM xxx WHERE xxx LIKE '%[_]d'