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 ?