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%');
Oracle-模糊查询忽略大小写
最新推荐文章于 2024-08-20 19:50:34 发布