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-. 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 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 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-%' 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 Link to comment https://forums.phpfreaks.com/topic/185062-case-sensitive/#findComment-977762 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.