微客导航 » 文章资讯 » 如何使用MySQL LIKE提取具有多个值的字段？

如何使用MySQL LIKE提取具有多个值的字段？

2024-05-17 21:02:05 508

要获取具有多个值的字段，请在MySQL中将LIKE与OR配合使用-

select *from yourTableName where yourColumnName like ‘%AnyStringValue’ or yourColumnName like ‘%AnyStringValue’ or yourColumnName like ‘%AnyStringValue’ ……...N;

您可以借助表格来了解-

create table LikeDemo
   −> (
      −> Hobby varchar(200)
   −> );

借助insert命令将一些记录插入表中。在表中插入记录的查询如下-

insert into LikeDemo values('Reading Book');

insert into LikeDemo values('Playing Cricket Match');

insert into LikeDemo values('Playing Hockey Match');

insert into LikeDemo values('Reading Novel');

insert into LikeDemo values('Swimming');

Displaying all records with the help of select statement. The query is as follows:

select *from LikeDemo;

以下是输出-

+-----------------------+
| Hobby                 |
+-----------------------+
| Reading Book          |
| Playing Cricket Match |
| Playing Hockey Match  |
| Reading Novel         |
| Swimming              |
+-----------------------+
5 rows in set (0.00 sec)

使用LIKE获取具有多个值的字段的查询如下-

select *from LikeDemo where Hobby like '%Cricket%' or Hobby like '%Reading%';

以下是输出-

+-----------------------+
| Hobby                 |
+-----------------------+
| Reading Book          |
| Playing Cricket Match |
| Reading Novel         |
+-----------------------+
3 rows in set (0.00 sec)

返回顶部
3162201930
czq8825@qq.com

如何使用MySQL LIKE提取具有多个值的字段？

热门推荐

随机推荐