MySQL LIKE query with underscore

Question

I have the following table images:

+----+--------------+ | id |   img_path   | +----+--------------+ | 1  | abc_1.jpg    | | 2  | abc_2.jpg    | | 3  | abcde_1.jpg  | | 4  | abcde_2.jpg  | | 5  | abcdef_1.jpg | +----+--------------+ 

I would like to select the entries that img_path starts with abc_, so I use the following query:

SELECT id FROM images WHERE img_path LIKE 'abc_%' 

But it returns all 5 rows. How do I only returns id = 1 & 2 ( which img_path starts with abc_) ?

Answer 1

Found out that _ is a special character. Have to escape with backslashes.

SELECT id FROM images WHERE img_path LIKE 'abc\_%' 

which returns 2 rows as expected