sandy1028 Posted December 14, 2009 Share Posted December 14, 2009 How to query the table, based on case-sensitive. SELECT * FROM table WHERE text LIKE '%M-%'. This will list out characters m- also. How to get the rows which has only M-. Quote Link to comment https://forums.phpfreaks.com/topic/185062-case-sensitive/ Share on other sites More sharing options...
PFMaBiSmAd Posted December 14, 2009 Share Posted December 14, 2009 http://www.phpfreaks.com/forums/index.php/topic,280549.0.html Quote Link to comment https://forums.phpfreaks.com/topic/185062-case-sensitive/#findComment-976864 Share on other sites More sharing options...
sandy1028 Posted December 14, 2009 Author Share Posted December 14, 2009 I do not have the permission to change in the phpMyAdmin. So is there any other way to match in the sql query it self Quote Link to comment https://forums.phpfreaks.com/topic/185062-case-sensitive/#findComment-976867 Share on other sites More sharing options...
rajivgonsalves Posted December 14, 2009 Share Posted December 14, 2009 something like this SELECT * FROM table WHERE BINARY(text) LIKE '%M-%' Quote Link to comment https://forums.phpfreaks.com/topic/185062-case-sensitive/#findComment-976871 Share on other sites More sharing options...
bowett Posted December 15, 2009 Share Posted December 15, 2009 You might want to also try LIKE BINARY Quote Link to comment https://forums.phpfreaks.com/topic/185062-case-sensitive/#findComment-977762 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.