Hi thanks for your reply,
But why didn't find_in_set respond when there is a space.
TIA
At 12:18 PM 4/16/99 +0200, Christian Mack wrote:
>"Yes!" wrote:
>>
>> 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!
>
>Hi YES!
>
>This isn't a bug. This is the desired behaviour.
>You don't have a SET member called 'nepathya' in nepal.music, so what
makes you belive you can get it out?
>If the column nepal.music is declared as CHAR or VARCHAR you can search with:
>SELECT * FROM nepal WHERE musik like '%nepathya%';
>
>Tschau
>Christian
>
>
>
