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/87189-solved-case-sensitive-search/ Share on other sites More sharing options...
beebum Posted January 22, 2008 Share Posted January 22, 2008 Try this: SELECT COUNT(*) as count FROM country_list WHERE country='India' COLLATE latin1_bin; Link to comment https://forums.phpfreaks.com/topic/87189-solved-case-sensitive-search/#findComment-446124 Share on other sites More sharing options...
pdkv2 Posted January 23, 2008 Author Share Posted January 23, 2008 Thank you very much !! Link to comment https://forums.phpfreaks.com/topic/87189-solved-case-sensitive-search/#findComment-446637 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.