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