one more for searching fulltext

sdizier

one more question how would you search mulitple feilds using
SELECT * FROM $dbTable WHERE artical LIKE '%searchString%'"
Slan

chris_e

SELECT * FROM $dbTable WHERE artical LIKE '%searchString%' OR field2 LIKE '%searchString%'"

sdizier

Thanks alot it works great
Slan

chris_e

np.

chriskl

Aaargh! Noooo!

Use FULLTEXT index:

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

Using LIKE is UNINDEXABLE and is probably the slowest possible way to search a set of text fields.

Chris

sdizier

I am using a FULLTEXT index, but instead of searching like this

$query = @("SELECT * FROM $dbTable WHERE MATCH(name,header,body) AGAINST ('$searchString')", $dbc)
or die("Could'nt match the table data in <b>$dbTable!</b>");

while($row = mysql_fetch_assoc($query)){
$head = $row["header"];
$id = $row["articalID"];
print $head<br>";
}

I changed my query to
SELECT * FROM $dbTable WHERE name LIKE '%searchString%' OR header LIKE '%searchString%' OR body LIKE '%searchString%'";

Which works great. Now, mind you my database is still quite small and still have to test the durability but other wise it works great.

sdizier

I was just thinking. Is my query ignoring my fulltext index and is serching my table feild by feild? Is that what you mean?
Slan