搜索其值中包含最后一个字符的表列

Question

I have an sql query to perform,

I have a column named as ringSetName with entries like

DFWR001921S
DFWER923231

Etc i want to get all entries with last character as S

I have tried using

SELECT * 
FROM rings
WHERE ringSetName LIKE  '%s'
LIMIT 0 , 30

It doesn't work

Answer 1

You can try using uppercase S if you use a case-sensitive collation

WHERE ringSetName LIKE  '%S'

Otherwise it should work. See this example from SQLFiddle