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:

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

Keywords:

  • 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 *