I have a field that contains a list of numbers seperated by commas.
For example, my field would contain something like this:
15,25,16,17,13,16
I only want to search for the very last item in the list. In this case it would be 16. My current SELECT looks like this:
SELECT * FROM `table` where `column` REGEXP ',[[:<:]]16[[:>:]]$'
It returns no records. Whats wrong with my SELECT?