Geek asks and answers

Mysql - an array in multiple columns

I have a row in the form $string = 'London,Paris,Birmingham', and I want to look for several columns to match these values.

for instance WHERE events.name, events.cities, events.counties IN (".($string).")

Can someone recommend me a simple and short way to do something like this.

+3
source share
1 answer

Use the FIND_IN_SET function :

WHERE (   FIND_IN_SET(events.name, mysql_real_escape_string($string)) > 0
       OR FIND_IN_SET(events.cities, mysql_real_escape_string($string)) > 0
       OR FIND_IN_SET(events.counties, mysql_real_escape_string($string)) > 0)
+5
source

More articles:


All Articles