i am having an issuse not sure how to approach this i have setup a area that grabs user's / user data by a search now i dont get the same results when i do lower case and uppser case any ideas ?
$query = "SELECT * FROM `users` WHERE `$lookby` LIKE '%$lookfor%'";Jump to PostWhat is the collation of $lookby? Did you alter table structure or upgraded MySQL?
What is the collation of $lookby? Did you alter table structure or upgraded MySQL?
Take a note all binary collation are case sensitive
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.