bulrush Posted August 11, 2010 Share Posted August 11, 2010 MySQL 4.1.11 My understanding is the LIKE clause is case-sensitive. How do I make it case-insensitive? When my users are adding to a list of names, I want to make sure they don't have that name on file already but in a different case. Quote Link to comment https://forums.phpfreaks.com/topic/210454-is-like-case-sensitive/ Share on other sites More sharing options...
fenway Posted August 11, 2010 Share Posted August 11, 2010 It's not -- where did you get that idea? Quote Link to comment https://forums.phpfreaks.com/topic/210454-is-like-case-sensitive/#findComment-1098149 Share on other sites More sharing options...
bulrush Posted August 11, 2010 Author Share Posted August 11, 2010 I read it on a web page somewhere, don't remember where. But after my testing I see it is not case sensitive. w3schools.com does not even mention case sensitivity. Quote Link to comment https://forums.phpfreaks.com/topic/210454-is-like-case-sensitive/#findComment-1098154 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.