php - CamelCase Issue In MySQL Query

Question

I just discovered an issue in my query where I match words that are CamelCased. I get the value from URI like this:

$county = $_GET['county'];

Then I pass it to my query and I noticed that only 'McMullen' or 'mcMullen' will work but anything else will fail. I tried to modify my query like this but nothing seems to work.

 WHERE LCASE(county) LIKE '%$county%'

 WHERE LCASE(county) LIKE '$county'

 WHERE LCASE(county) = '$county'

 WHERE LCASE(county) LIKE '%$county%'

 LOWER(CONVERT(county USING utf8mb4))  LIKE '$county'

What am I missing?

question from:https://stackoverflow.com/questions/65871585/camelcase-issue-in-mysql-query

Answer 1

Sorry, my bad, I think I figured it out. The evaluation happens elsewhere, not in the query, which works fine.