Oracle-模糊查询忽略大小写

xiaoxiao2021-03-26 25

select * from table t where upper(t.name) like '%F%';--将字段全转成大写 select * from table t where lower(t.name) like '%f%'; --将字段全转成小写 select * from table t where t.name like upper('%f%') or t.name like lower('%F%');

转载请注明原文地址: https://ju.6miu.com/read-659933.html

技术

最新回复(0)