I am having trouble with a PHP MySQL search engine I built for my website using the MATCH() AGAINST() method. My searches should return results without regard to case-sensitivity, but this is not the case. If I search for Camera, camera, or CAMERA I get different (sometimes no) results for each. My columns are collated to latin1_swedish_ci. Each column has a FULLTEXT index. I'm using the BOOLEAN mode as well. Using
to grab the search term from my form...
This is my current MySQL query...
$query = ("SELECT * FROM `table` WHERE MATCH(title,price,category) AGAINST
('$searchterm' IN BOOLEAN MODE)")or die(mysql_error());
Any thoughts? What am I missing?