FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


mysql table keyword search





kv
I want to build a search feature for my website. I can't use standard indexed search because the entire contents of my site is in the database. Is there a way I can search a mysql table using keywords like a search engine? I don't want to perform "Contains" query. It should return the row even if 3 of 5 keywords match or the keyword "sounds" like something in the row.
mathiaus
I would suggest using a script from one of these links
http://www.phpfreaks.com/quickcode_cats/25/Searches.php
http://www.phpfreaks.com/scripts/Search_Engines/2.php
http://www.phpfreaks.com/tutorials/129/0.php
http://hotscripts.com/search/7458181.html

I dont use a script myself nor have ever tried so cant personally suggest one either though I do use a remotly hosted search at http://www.freefind.com/
basicly they index your site and provide you a seacrh bar. when form is filled you are sent to apage witht he results from your site.
An example can be seen on my site (link in sig)

Hope this helps
Matt
kv
Thanks a lot. I figured out mysql full text search was what I was looking for.
Related topics
E-Cards with PHP & MySQL
HTTP AUTH with PHP and mySQL
My first 2 Pages
Working with Excel, PHP & MySQL. Any Ideas
SELECTing from MySQL with PHP
Can't create mySQL table
Export and Import Mysql Table
how to selecting this from a mysql table ?
advanced search engine
Creating a good search engine
a new mysql table...
Subtrat values to a mysql table script
Search Script
What to learn first?
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.