On 12/11/03 12:24 -0600, Adam Williams wrote:
> So as you can see, its gonna need some work to make it do fulltext
> searching of the descr field. I'm not really sure how to make it do a
> keyword search, either since "holmes*north*carolina" doesn't work
> because it only searches for those words in that order, if descr field
> in the database contains "north carolina holmes" it won't return that
> result, but I want it to because the person using the db is looking for
> all the fields that contain holmes, north, and carolina.
On MySQL may be a query like this should do the trick...
select * from match_test where mytext like "%north%" and mytext like
"%holmes%" and mytext like "%carolina%";
An intersection of the results of independent matches, or simply put an
"and" logic. This query would be pretty slow on large databases I
CCK./ cck[at]ilug-hyd.org.in/[EMAIL PROTECTED] <http://hserus.net/~cck>
"Passion and gradualness" -- Pavlov.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php