Text Area CSV Search

[Matl]

Hello,

I have a very basic search form that I would like to be able to pass to my PHP processing script so that a single column in the Mysql table can be matched against all comma separate values that the user enters into the form text area field.  I can't seem to get the exact solution.

 

Form text area is named: center

 

$centersearch=$_POST["center"];

 

SELECT * FROM cities WHERE center LIKE '%$centersearch%'

Would I need to do a pregreplace to eliminate the commas before using them in my query or enter them into an array of some sort?

 

Thanks in advance!

[Matl]

Oh yes, this is on RHEL 5, Apache 2.2.3, Mysql 5.0.77 and PHP 5.2.10

[fenway]

If it's really comma separated, you can cheat with FIND_IN_SET().