How to match Underscore in String - MYSQL

user_2349450 0
Viewed 6413

if column value is 2_apples or final_chapter how do i match a value that contains an underscore "_" ?

I've tried with: 

SELECT DISTINCT brand FROM `items` WHERE brand like '%\\_'
SELECT DISTINCT brand FROM `items` WHERE brand like '_'
SELECT DISTINCT brand FROM `items` WHERE brand like '%_%'
SELECT DISTINCT brand FROM `items` WHERE brand like LIKE '\_'

It either shows all results or none. Any suggestions?

mysql
1 Answers
Related