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