Browsing: SQL

Select Case Sensitive in MySQL

Today I found bug on my website while using MySQL query. I just realized that the search function works in case insensitive. If I execute this query: SELECT filename FROM data_ebook WHERE filename = ‘Manasik_Haji_dan_Umroh.pdf’ the results will be: — Manasik_Haji_dan_Umroh.pdf Manasik_Haji_Dan_Umroh.pdf — By using keyword ‘LIKE BINARY’ it can make the result case sensitive:…