pdkv2 Posted January 22, 2008 Share Posted January 22, 2008 Hi all How can i make the case sensitive search in my query given below 1.SELECT COUNT(*) as count FROM country_list WHERE country='india'; 2.SELECT COUNT(*) as count FROM country_list WHERE country='India'; Both the sql gives same output(on windows and unix) i am using mysql 5.0 Regards Sharad Link to comment https://forums.phpfreaks.com/topic/87190-solved-case-sensitive-search-in-mysql/ Share on other sites More sharing options...
mmarif4u Posted January 22, 2008 Share Posted January 22, 2008 SELECT COUNT(*) as count FROM country_list WHERE binary country='india'; Hope this will help. Link to comment https://forums.phpfreaks.com/topic/87190-solved-case-sensitive-search-in-mysql/#findComment-445954 Share on other sites More sharing options...
pdkv2 Posted January 22, 2008 Author Share Posted January 22, 2008 Thanks a ton for your solution Link to comment https://forums.phpfreaks.com/topic/87190-solved-case-sensitive-search-in-mysql/#findComment-445956 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.