Keyword Search 2

[bam720]

So I have a ticket system set up. In each ticket there is a Keyword field. I would like to be able to serach the databse for these keywords and return possible tickets. The only part I am confused about is the SQL for grabbing similar keywords, which may or may not be seperated by comas. If anyone has done this or can point me in the right directions it would be much appreciated. Thanks.

 

[jpadie]

sounds like a question for the mysql forum.

but i'd guess something like this might work

select * from table where keywordfield like '%somevariable%'

 

[bam720]

Thanks for the help. Was exactly what I was working for. Sorry for the delayed reply I was implmenting another feature