user1810868 user1810868 - 2 months ago 7
MySQL Question

Query to select strings end with certain character

I have a column that contains strings as:

aaa_1
aaa_11


I need to query strings that ends with
_1
. I tried the following:
select col from table where col like
%_1
;
But the query gives me the strings that ends with
_1
and
_11
. How can I correct this ?

Answer

Try this:

select col from table where col like '%\_1'

character _ is a jolly, like %, but it matches only a single character, so you have to escape it with \

See here: http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like

Comments