I have a column called 'music' in 'nepal' table where it contains
group
=============================
jackson,nepathya group,ub40
I need to display the above row When the user input 'nepathya group'.
I used
mysql> select * from nepal where find_in_set('nepathya group',music);
+-----------------------------+
| music |
+-----------------------------+
| jackson,nepathya group,ub40 |
+-----------------------------+
it worked!!
but it won't
mysql>select * from nepal where find_in_set('nepathya',music);
Empty set (0.01 sec)
I think there is some bugs in find_in_set function.
I am using MYSQL server version: 3.22.20a-log in Redhat Linux 5.2
TIA
Regards,
YES!