mybatis自动构建时怎么处理有空格字段
发布网友
发布时间:2023-04-25 05:10
我来回答
共1个回答
热心网友
时间:2023-10-14 11:42
去除左边空格LTRIM
SELECT LTRIM(column_name) FROM table_name WHERE ...
去除右边空格RTRIM
SELECT RTRIM(column_name) FROM table_name WHERE ...
去除前后空格TRIM
SELECT TRIM(column_name) FROM table_name WHERE ...