troubleshooting Question

MySQL and PHP: MATCH() AGAINST() Case-Sensitivity Issue

Avatar of lleblanc65
lleblanc65Flag for United States of America asked on
Microsoft SQL ServerPHPMySQL Server
4 Comments1 Solution1231 ViewsLast Modified:
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
$_GET['searchterm'];
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?
ASKER CERTIFIED SOLUTION
Sandeep Kothari
Project Lead

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros