[PHP] PHP and MySQL Full Text Search Problem

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'] . '); This

Re: [PHP] PHP and MySQL Full Text Search Problem

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.