I am trying to return the exact matching row from mysql in php.The column type is varchar so i use wild char characters to return the row but it didn't work.I also tried to use IN statement in my sql but it also didn't work.
I would like to explain the problem scenario as follows:
Code: Select all
TableName: users
userid username matchtypes
1 Bob 1,4,5,13
2 Jessica 3,21,45,67
3 Ken 13,42,12
4 Stephe 103,24,203
5 Andrew 3,12,45Code: Select all
select * from users where matchtypes like '%3%'Is thery any sql statement which i can use to extract the exact records.
Thanx in advance