MySql学习笔记4：模糊匹配语句

最新推荐文章于 2021-11-27 22:46:36 发布

blue95wind

最新推荐文章于 2021-11-27 22:46:36 发布

阅读量484

点赞数 1

分类专栏： MySQL学习文章标签： sql语句

本文链接：https://blog.csdn.net/blue95wind/article/details/38959521

版权

MySQL学习专栏收录该内容

5 篇文章 0 订阅

订阅专栏

表名：info_user

字段：id、name、borndata、age、sex、email、sail

4. like 操作符

4.1 % 通配符

<span style="white-space:pre">	</span>SELECT  id,name,borndata FROM  info_user  WHERE name LIKE 'j%';

<span style="white-space: pre;"></span><pre name="code" class="sql" style="font-family: Arial; color: rgb(51, 51, 51); font-size: 14px; line-height: 26px;"><span>	</span>SELECT  id,name,borndata FROM  info_user  WHERE name LIKE '%h'; 
<span style="color: rgb(51, 51, 51); font-family: monospace; font-size: 14px; line-height: 26px; white-space: pre;">	</span><span style="color: rgb(51, 51, 51); font-family: monospace; font-size: 14px; line-height: 26px; white-space: pre; background-color: rgb(240, 240, 240);">SELECT  id,name,borndata FROM  info_user  WHERE name LIKE 'j%n';</span>

<span>	</span>SELECT  id,name,borndata FROM  info_user  WHERE name LIKE '%e%';  <span style="font-family: Arial;"> </span>

<span style="font-family: Arial;"><span style="white-space:pre">	</span>注意：</span>

<span style="font-family: Arial;"><span style="white-space:pre">	</span>1. %可以代表0、1、多个字符 </span>

<span style="font-family: Arial;">        2. 注意尾空格：如果字段值最后有个空格，那么使用第二句查询是没有结果的。</span>

<span style="font-family: Arial;"><span style="white-space:pre">	</span>3. 对于 like ‘%’ 来说，字段值为null是搜索不出的。</span>

<span style="font-family: Arial;">
</span>

<span style="font-family: Arial;">4.2  _  通配符</span>

<span style="color: rgb(51, 51, 51); font-size: 14px; line-height: 26px; white-space: pre; background-color: rgb(240, 240, 240);"><span style="font-family:Arial;">        </span></span><span style="font-family: monospace; color: rgb(51, 51, 51); font-size: 14px; line-height: 26px; white-space: pre; background-color: rgb(240, 240, 240);">SELECT  id,name,borndata FROM  info_user  WHERE name LIKE 'Luc_';</span>

<pre name="code" class="sql" style="color: rgb(51, 51, 51); font-size: 14px; line-height: 26px; font-family: Arial;"><span>	</span>注意：
<pre name="code" class="sql" style="color: rgb(51, 51, 51); font-size: 14px; line-height: 26px; font-family: Arial;"><span>	</span>_ 只可以代表 单个字符。

SELECT id,name,borndata FROM info_user WHERE name LIKE 'j%n';