var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help matching best match (using REGEXP)
I have a table full of regexes (like the one bellow)
I need a query to retrieve the part_match of the BEST match for 'FF2-0F4J-YJKNC'
I tried going 'FF2-0F4J-YJKNC' regexp match_match ORDER BY length( part_match ) DESC and grab the first row returned, but will not work because this will return row 3 first but the best match is row
Does any one know how to solve this problem by only using a MYSQL query?
Obviously this is an example, the actual table is huge and I need something works for any input
Thank you !!
Last edited by mc_line; 11-24-10 at 14:53.