mysql fulltext

[nivashni]

Hi Please could someone tell me if my syntax is correct here.

I want to make sure that if the word or phase that is search for is
in lower case, just in case there is a difference in the case of the text between the DB and the user request

$sql = "SELECT id, title,
MATCH(title,lower(body))
AGAINST ('$searchwords') AS score FROM mytable
WHERE MATCH(title,lower(body))
AGAINST ('$searchwords') ORDER BY score DESC";

[nivashni]

Hi Everyone

Is fulltext really the answer to create a website search or would it be better to use the google api instead to search your site.

Thanks
Niva

[r937]

Hi Please could someone tell me if my syntax is correct here.

yes, if you remove the LOWER() function

mysql fulltext search is case-insensitive