已解决问题
谷歌coolerser用户在2013.08.02提交了关于“钵钵鸡Oracle**库sql语句模糊查询问题”的提问，欢迎大家涌跃发表自己的观点。目前共有1个回答，最后更新于2024-12-14T01:06:15。用户表是scott用户下的emp表:问题时这样的:查询在1981年入职的所有员工
我用模糊查询做的
select*fromempwherehiredatelike'%81%';
但是如果我改成
select*fromempwherehiredatelike'%981%';或者
select*fromempwherehiredatelike'1981%';或者
select*fromempwherehiredatelike'_981%';
就差不出任何记录
为什么呢？
SQL>select*fromempwherehiredatelike'%981%';
EMPNOENAMEJOBMGRh**IREDATESALCOMMDEPTNO
----------------------------------------------------------------
SQL>select*fromempwherehiredatelike'%81%';
EMPNOENAMEJOBMGRh**IREDATESALCOMMDEPTNO
----------------------------------------------------------------
7499ALLENSALESMAN76981981-2-201600.00300.0030
7521WARDSALESMAN76981981-2-221250.00500.0030
7566JONESMANAGER78391981-4-22975.0020
7654MARTINSALESMAN76981981-9-281250.001400.0030
7698BL**EMANAGER78391981-5-12850.0030
7782CLARKMANAGER78391981-6-92450.0010
7839KINGPRESIDENT1981-11-175000.0010
7844TURNERSALESMAN76981981-9-81500.000.0030
7900JAMESCLERK76981981-12-3950.0030
7902FORDANALYST75661981-12-33000.0020
10rowsselected希望大家能够帮助她。
详细问题描述及疑问：用户表是scott用户下的emp表:
问题时这样的:查询在1981年入职的所有员工
我用模糊查询做的
select*fromempwherehiredatelike'%81%';
但是如果我改成
select*fromempwherehiredatelike'%981%';或者
select*fromempwherehiredatelike'1981%';或者
select*fromempwherehiredatelike'_981%';
就差不出任何记录
为什么呢？
SQL>select*fromempwherehiredatelike'%981%';
EMPNOENAMEJOBMGRh**IREDATESALCOMMDEPTNO
----------------------------------------------------------------
SQL>select*fromempwherehiredatelike'%81%';
EMPNOENAMEJOBMGRh**IREDATESALCOMMDEPTNO
----------------------------------------------------------------
7499ALLENSALESMAN76981981-2-201600.00300.0030
7521WARDSALESMAN76981981-2-221250.00500.0030
7566JONESMANAGER78391981-4-22975.0020
7654MARTINSALESMAN76981981-9-281250.001400.0030
7698BL**EMANAGER78391981-5-12850.0030
7782CLARKMANAGER78391981-6-92450.0010
7839KINGPRESIDENT1981-11-175000.0010
7844TURNERSALESMAN76981981-9-81500.000.0030
7900JAMESCLERK76981981-12-3950.0030
7902FORDANALYST75661981-12-33000.0020
10rowsselected期待您的答案，你无异于雪中送炭,让我感激涕零
！