TRIM()
函数去除字符串两端的空格,结合 LIKE
进行模糊查询。SELECT * FROM table_name WHERE TRIM(column_name) LIKE '%keyword%';
TRIM()
函数去除字符串两端的空格,结合 LIKE
进行模糊查询。SELECT * FROM table_name WHERE TRIM(column_name) LIKE '%keyword%';
Powered By Z-BlogPHP 1.7.3
Copyright Your WebSite.Some Rights Reserved.