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
MySQL LIKE query with underscore
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