错误写法:select * from T_SYS_USERS t where LOWER( t.user_account)='ABC';
正确写法:select * from T_SYS_USERS t where t.user_account=LOWER('ABC');
sql转换大小写的对错写法
最新推荐文章于 2022-01-13 18:40:32 发布
错误写法:select * from T_SYS_USERS t where LOWER( t.user_account)='ABC';
正确写法:select * from T_SYS_USERS t where t.user_account=LOWER('ABC');