Re: How to use Full text search?

What database is being used? How is the target structured and are there indexes to use? My concern with this approach, though I don't have a better one, is that it will be deathly slow as the database grows. I'd suggest a double check of the database documentation. Just a couple of random thoughts - Miles Thompson At 08:40 AM 7/18/2002 -0400, Jeffrey_N_Dyke@Keane.com wrote:

I break up the search words using a function and then build a query based on the search criteria. If it is multiple words, I use REGEXP for the search.( I use a mysql database). then when there are multiple searches you can format the query string like.... SELECT show_name FROM table_of_shows WHERE show_name REGEXP 'simpsons|sienfield' using the LIKE you can do the same thing....using a function to break up the query string... SELECT show_name FROM table_of_shows WHERE show_name like '%simpsons%' OR show_name like '%sienfeld%' etc.... Hope this helps. Jeff

                    Dasmeet Singh 
                    <dasmeet@tunma       To:     php-db@lists.php.net 
                    il.com>              cc: 
                                         Subject:     Re: [PHP-DB] How to use Full text search?
                    07/18/2002 
                    05:54 AM 

Martin Clifford wrote: 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) Thanx, I am already using 'Like' search but it doesnt seems to be helpful when more than one keywords are entered. If you have any solution, please send it to me. Thanx again. Dasmeet 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php