12、MySQL的通配符数据过滤，模糊匹配

最新推荐文章于 2023-11-09 19:28:40 发布

dingpython

最新推荐文章于 2023-11-09 19:28:40 发布

阅读量113

点赞数

分类专栏： MySQL 文章标签： mysql

本文链接：https://blog.csdn.net/dingpython/article/details/113051005

版权

JetPack LIKE操作符 MySQL 模糊搜索 prod_name

关键词由CSDN通过智能技术生成

MySQL 专栏收录该内容

39 篇文章 0 订阅

订阅专栏

like操作符
%代表任意多个字符

mysql> select * from products where prod_name like 'jet%';
+---------+---------+--------------+------------+---------------------------------------+
| prod_id | vend_id | prod_name    | prod_price | prod_desc                             |
+---------+---------+--------------+------------+---------------------------------------+
| JP1000  |    1005 | JetPack 1000 | 35.00      | JetPack 1000, intended for single use |
| JP2000  |    1005 | JetPack 2000 | 55.00      | JetPack 2000, multi-use               |
+---------+---------+--------------+------------+---------------------------------------+
2 rows in set (0.18 sec)