LIKE

[Anon]

Hi, im trying to make a feature so you can search through my news database. Below is the code.

$Link = mysql_connect ($Host, $DBUser, $DBPass);
$Query = "SELECT * from News WHERE News LIKE '%$text%'";
$Result = mysql_db_query ($DBName, $Query, $Link);
while ($news = mysql_fetch_array($Result)) {
print("$news[News]");
}

This searches for $text in the database which works fine. I really need it to be able to search for multiple words.... does anyone know how i would go about doing this?

Thanks

[Anon]

have you read this?

http://www.phpbuilder.com/columns/clay19990421.php3

[mattw]

If your mysql version supports it, I would look into full text indexing/searching. Very cool stuff. I can't wait for version 4.0 of mysql to go into production, because at that point boolean searches will work. Anyway, here is a link:

http://www.mysql.com/doc/F/u/Fulltext_Search.html

Matt Wade
codewalkers.com

[Anon]

Thanks to both of you.

[[deleted]]

fulltext may be cool in 4.0, but the 'current' fulltext is crap. It only recognizes whole words, which makes it quite useless compared to a keyword-index as described in the infamous 'slapping together a search-engine' article.