How to search mulitple value seperated by commas in mysql

Posted by Fero on Stack Overflow See other posts from Stack Overflow or by Fero
Published on 2010-05-01T11:34:22Z Indexed on 2010/05/01 11:37 UTC
Read the original article Hit count: 127

Filed under:
|

Hi all,

How to search multiple values separated by commas.

ex:

table name : searchTest

id    name      keyword

1     trophy1   test1,test2,test3

2     trophy2   test2,test5

Points:

  1. If i search for test2 both results trophy1 and trophy2 should be display.

  2. If i search for trophy1 then trophy1 should be as result.

How to solve this issue.

thanks in advance

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql