Search-Engine for MySQL an Weblike Requests!
| From: | Oliver Kuhl | Date: | Tue, 06 Jun 2000 11:19:08 +0000 |
| Subject: | Search-Engine for MySQL an Weblike Requests! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-1124@lists.php.net to get a copy of this message | ||
Hi!
I'm looking for a class or function, which provides the construction of a
MySQLQuery-String directly from an enterd searchstring like:'+"the rock"
+movie -geography'
Additional, the function should allow to enter the tablename, the fields (in
which I want to search) and the fields I want to receive. The function
should return something like that:
'SELECT id, description FROM tablemovie WHERE ((name LIKE "%the
rock%")OR(content LIKE "%the rock%"))AND ((name LIKE "%movie%")OR(content
LIKE "%movie%"))AND NOT((name LIKE "%geography%")OR(content LIKE
"%geography%"))
Does anyone know, where I can find this function? Else I have to code it
myself, but I'm to lazy for it! ;)
Regards,
Oliver.