A little REGEX help please!

Hi all, I’ve successfully implimented loooaddss of custom member list with searches, however I now have a client that wants to use the mutli select box feature. My current code falls down here as the REGEX I use to select the category from the meta_value field only works with the single select box.

Here is the data as it appears in the database:

s:8:"category";a:1:{i:0;s:17:"Business services";}}

Here is my current AND line in my SQL statement

AND UMS.meta_value REGEXP '.*"".$_SESSION['searchfield']."";s:[0-9]+:".*".$_SESSION['searchvar'].".*".*'

How can I modify the above to work with the new multi option data?? I’ve tried a few things but REGEX is hardly a strong point of mine.

Cheers!!!

Zoe

Is anyone able to help with this at all? Am rather stuck and my client needs this feature…

Cheers!

Zoe

As a regex, something like this might work:

AND UMS.meta_value REGEXP '[^"]+\"" . mysql_real_escape_string( $_SESSION['searchfield'] ) . "\".+\"" . mysql_real_escape_string( $_SESSION['searchvar'] ) . "\"'

A quick hack might be

AND UMS.meta_value LIKE '%" . $_SESSION['searchfield'] . "%' AND UMS.meta_value LIKE '%" . $_SESSION['searchvar'] . "%'