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
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:
If i search for test2 both results trophy1 and trophy2 should be display.
If i search for trophy1 then trophy1 should be as result.
How to solve this issue.
thanks in advance
© Stack Overflow or respective owner