Since you are using fulltext search it is going to look for the exact
spelling of what you pass in.
If you wanted to get matches with Chris then you will want to modify
your query by using LIKE.
In version 4.0.1 of mysql you can do fulltext search in boolean mode.
http://www.mysql.com/doc/en/Ful
Hi all,
My first try at MySQL Full Text Search and it is not behaving ;)
Here is what I have for my query string:
$sql = "SELECT id, concat(fname, ' ', lname, ' ', degree1) as name".
" FROM tbl_personnel WHERE MATCH (fname,lname) AGAINST ('" .
$attributes['searchstring'] . "')";
Th
2 matches
Mail list logo
