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:


By using keyword ‘LIKE BINARY’ it can make the result case sensitive:

SELECT filename FROM data_ebook WHERE filename LIKE BINARY 'Manasik_Haji_dan_Umroh.pdf'


  • speedup pad slim s5
  • scripps networks
  • Powered by Article Dashboard how to open a ttf file
  • Powered by Article Dashboard salmon cooking tips

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.