Mysql常用语句

Mysql 语句

1. 模糊查询

所查询字段 + like '%米%'

eg:select * from user where realname like '%米%'

Mabatis语句

1. 模糊查询

SELECT * FROM table WHERE name LIKE CONCAT(CONCAT('%', #{text}), '%')