The Little Guy Posted October 13, 2008 Share Posted October 13, 2008 How would you do a Case Sensitive MySQL search? SELECT * FROM search_video WHERE id = '%s' %s = some id value so... xXx != xxx Link to comment https://forums.phpfreaks.com/topic/128210-solved-cas-sensitive-mysql/ Share on other sites More sharing options...
MadTechie Posted October 13, 2008 Share Posted October 13, 2008 try this SELECT * FROM search_video WHERE BINARY id = '%s' Link to comment https://forums.phpfreaks.com/topic/128210-solved-cas-sensitive-mysql/#findComment-664026 Share on other sites More sharing options...
The Little Guy Posted October 13, 2008 Author Share Posted October 13, 2008 I just changed the "Collation" to "latin1_general_cs" That works Link to comment https://forums.phpfreaks.com/topic/128210-solved-cas-sensitive-mysql/#findComment-664028 Share on other sites More sharing options...
MadTechie Posted October 13, 2008 Share Posted October 13, 2008 lol, yeah that will work as well Link to comment https://forums.phpfreaks.com/topic/128210-solved-cas-sensitive-mysql/#findComment-664029 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.