zooooooh的博客

1.sql中字符串拼接 select * from t_user WHERE user_name LIKE CONCAT(concat('%', #{test}),'%');2.使用 ${…} 代替#{…} select * from t_user WHERE user_name LIKE '%${text}%';3.大小写匹配查询 select * from t_user WHERE

MYSQL:INNER JOIN的用法inner join的用处：使用于多表查询关键字：onon:后面直接跟条件表达式实例代码块select u.user_name,i.info_phone from user uinner join userInfo i onu.user_id=i.user_id