1.WHERE 字句
使用 BINARY 關鍵字使搜尋區分大小寫
建立表:bill
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiAzNvwVZ2x2bzNXak9CX90TQNNkRrFlQKBTSvwFbslmZvwFMwQzLcVmepNHdu9mZvwFVywUNMZTY18CX052bm9CXwsmaOBTWU9UNNpHW4Z0MMBjVtJWd0ckW65UbM5WOHJWa5kHT20ESjBjUIF2LcRHelR3LcJzLctmch1mclRXY39jN4YjM0gDN2EDOykDM4EDMy8CX0Vmbu4GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.jpg)
eg1:SELECT * from bill WHERE BINARY detail='12er' --- 結果區分大小寫
但是SELECT * from bill WHERE detail='12er' ,不區分,
1.WHERE 字句
使用 BINARY 關鍵字使搜尋區分大小寫
建立表:bill
eg1:SELECT * from bill WHERE BINARY detail='12er' --- 結果區分大小寫
但是SELECT * from bill WHERE detail='12er' ,不區分,