You can do the same thing with like:
where concat(",",myField,",") like "%,$searchString,%"
this will of cause be somewhat slow, how about normalizing your database:
header(id,fields)
type(id,dataset)
header(1,....)
type(1,black)
type(1,dark)
...
now you can select * from header,type where (id=id) and dataset
in("...","...") group by id
So long
Martin
-----Original Message-----
From: Thalis A. Kalfigopoulos [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 08, 2001 11:42 AM
To: John Hart
Cc: [EMAIL PROTECTED]
Subject: Re: Working with FIND_IN_SET
On Sun, 8 Apr 2001, John Hart wrote:
> I am working on a rather large database project, in which I am making a
text column that contains different data, seperated by commas. What I need
to do is run a query where I will return only the datasets that contain any
of sets that partially, or fully match any data in the set...
>
> For example, if the dataset contains:
>
> dark, black, small
>
> I want to be able to return this data if the query contains ran contains
any of the following matches:
>
> dark
> black
> small
> sma
> bla
> ...etc...
>
> I do not, however, want a full LIKE search with wildcards, because I do
not want to return the set if they were to search on 'all' (which would
match smALL).
>
> Is there an easy way to do this, or am I forced into matching entire words
in a set?
>
> I appreciate any help anyone could offer me... Thank you...
>
> John
>
If I got you correctly, you might consider RLIKE where you define the
mathing string as a regular expressions. So in you case the regexp would be
something like:
RLIKE ".*, YOUR_QUERY_STRING_HERE.*, .*"
regards,
thalis
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
