1、upper()是转化为大写,我可以把字段和比对值都转成统一的大写
select * from unit_verify_situation where upper(verification_code) = upper('Th5ops') ORDER by update_time desc limit 1
2、lower()是转化为小写,我可以把字段和比对值都转成统一的小写
select * from unit_verify_situation where lower(verification_code) = lower('Th5ops') ORDER by update_time desc limit 1