【MySQL】查询时强制区分大小写的方法

查询

<span style="color: #0000ff">SELECT</span> <span style="color: #808080">*</span> <span style="color: #0000ff">FROM</span> U <span style="color: #0000ff">WHERE</span> <span style="color: #0000ff">binary</span> name <span style="color: #808080">LIKE</span> <span style="color: #ff0000">‘</span><span style="color: #ff0000">a%</span><span style="color: #ff0000">‘</span><span style="color: #000000">;  
</span><span style="color: #0000ff">SELECT</span> <span style="color: #808080">*</span> <span style="color: #0000ff">FROM</span> U <span style="color: #0000ff">WHERE</span> <span style="color: #0000ff">binary</span> name <span style="color: #808080">LIKE</span> <span style="color: #ff0000">‘</span><span style="color: #ff0000">A%</span><span style="color: #ff0000">‘</span><span style="color: #000000">;  
<br></span>

<span>仅仅多了一个binary，就可以得到不同的结果！</span>

【MySQL】查询时强制区分大小写的方法

标签：class   sel   查询   信息   资源   ble   大小   varchar   bsp