mysql is array in multiple columns

Question

I have a string in the form $string = 'London,Paris,Birmingham' and I want to search multiple columns for occurences of these values.

For example WHERE events.name, events.cities, events.counties IN (".($string).")

Can someone recommend me a simple and short way of doing something like this.

OMG Ponies · Accepted Answer · 2010-10-19 18:52:33Z

6

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)

answered Oct 19, 2010 at 18:52

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql is array in multiple columns

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related