在表中有一个字段
FLHIDNAME
1
2
1
2
2
2
1
如何可以用模糊查询把他们全查出来SELECT *
FROM sys_v_AllData
WHERE (FLHIDNAME LIKE '%12%')为何这样不可以显示全部内容
FLHIDNAME
1
2
1
2
2
2
1
如何可以用模糊查询把他们全查出来SELECT *
FROM sys_v_AllData
WHERE (FLHIDNAME LIKE '%12%')为何这样不可以显示全部内容
FROM sys_v_AllData
WHERE (FLHIDNAME LIKE '%12%')
%%是通配符 意思是12前面无数个字符和12后面无数个字符
结果:
1
2
1
2
2
2
1
SELECT *
FROM sys_v_AllData
WHERE (FLHIDNAME LIKE '%1%') or (FLHIDNAME LIKE '%2%')
FROM sys_v_AllData
WHERE (FLHIDNAME LIKE '%1%' or FLHIDNAME LIKE '%2%')
--测试:create table sys_v_AllData(FLHIDNAME int)insert into sys_v_AllData select 1
insert into sys_v_AllData select 2
insert into sys_v_AllData select 1
insert into sys_v_AllData select 2
insert into sys_v_AllData select 2
insert into sys_v_AllData select 2
insert into sys_v_AllData select 1
select * from sys_v_AllData where FLHIDNAME like '%[12]%'/*
FLHIDNAME
-----------
1
2
1
2
2
2
1
*/drop table sys_v_AllData
WHERE au_lname LIKE '[C-P]arsen' 将查找以arsen 结尾且以介于 C 与 P 之间的任何单个字符开始的作者姓氏,例如,Carsen、Larsen、Karsen 等。