MYSQL field with multiple keywords search

[fraser5002]

Hi,

 

Im new to MYSQL and i have just been playing around with it i have managed to set up a simple search page to search my SQL database and display records that match my input.

 

But what i really want is to have one of the fields in my database for the record called keywords and have multiple values in here separted by commas e.g

 

keyword1,keyword2,keyword3,keyword4

 

and the user will type in a search query and if it equals any of these above keywords in the field for that record it will return the record as normal.

 

How do i do this or is there a better way of doing what i want to achieve?

 

Thanks

 

 

 

[mapleleaf]

I think you may want find_in_set($_POST['keyword'], column_name);