Re: How to use Full text search?
| From: | Martin Clifford | Date: | Thu, 18 Jul 2002 12:26:06 +0000 |
| Subject: | Re: How to use Full text search? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20617@lists.php.net to get a copy of this message | ||
The query you would need would be something along the lines of:
SELECT show_name FROM table_of_shows WHERE show_name LIKE '%$keyword%'
Learning the LIKE syntax is going to be the best help to you in this situation, I believe ;o)
Martin Clifford
Homepage: http://www.completesource.net
Developer's Forums: http://www.completesource.net/forums/
>>> Dasmeet Singh <dasmeet@tunmail.com> 07/18/02 03:57AM >>>
I am developing a site which shows tv schedules online...
http://www.einFotimes.com I want to add search to it.
Basically i want to know how to full text search through all the tables
in database and i also want the name of table in result along with
fields...is it possible?
Dasmeet
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php