Mysql Site Search? --Searching a Mysql Database...

Black_Hobbit

Hi.

I'm in the process of creating a site search engine (Or about to start). I've searched through the mysql functions and can't seen to find what I want. So, lets say that I've got this mysql table called search:

|id|Title|Words|Description|Pageurl|
__________________________
|1|mypage|mine, me, myself, i|This is my page|[url]http://mysite.net/mine[/url]|
__________________________________
|2|somepage|other, that, it|This is the other |[url]http://mysite.net/other[/url]|

Ok, So once I've got connected to the DB, is there a way that I can efficiantly search through all the rows(maybe using a while) to find words (in the words colum) what match the search?

so, then, if $mysearch = "mine"; then the function would return the $id of the row that had the hit. In this case it would return 1.

Is that possible? If so, please give examples of some search code.

Thanks!

ScubaKing22

Use the "LIKE" statement:

mysql_query("SELECT id FROM search WHERE words LIKE '%$mysearch%'");

The LIKE statement is basically what it says; it selects the "id" of "words" that are like $mysearch. The % is a wildcard, so for a search to return more results you'd want to include that.

yelvington

In addition to what Scubaking cited, you should take a look at the full-text natural-language search capability that is in new releases of MySQL:

http://www.mysql.com/doc/en/Fulltext_Search.html

However, for the specific example you used, LIKE is the right tool for the job.

ednark

you might want to go to the phpbuilder.com frontpage.. as of the time of this post there is an article on the front page about full text site searching