var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need help with using REGEXP in my SELECT statement
I have a field that contains a list of numbers seperated by commas.
For example, my field would contain something like this:
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?
Last edited by ral1239; 09-16-11 at 11:11.
use the SUBSTRING_INDEX function for this, with -1 to designate the last item in the list