Select * in table Where field IN string
Hi,
I would like to add something equivalent to the following in my DataAssist search:
"SELECT * FROM allshows WHERE zip IN ('$zipcodes')";
I do no see an "IN" comparison in the DataAssist server behavior configuration. I already have other search criteria in there, so I would like to add the above in some way. $zipcodes is a string of comma separated zip codes derived on a separate search before hand.
Thanks for any assistance you can provide.