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 Quote 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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.