时间:2021-07-01 10:21:17 帮助过:16人阅读
查询
- <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