user1810868 user1810868 - 1 year ago 69
MySQL Question

Query to select strings end with certain character

I have a column that contains strings as:


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

Answer Source

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:

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download