mysql 关于concat()用法小解
concat():函数用于将多个字符串连接成一个字符串
例如:
SELECT * FROM `member_info` WHERE `is_del` = '0' AND concat(`member_account`, `member_realname`, `member_telephone`) LIKE '%测试%'
等同:
SELECT * FROM `member_info` WHERE `is_del` = '0' AND ((`member_account` LIKE '%测试%') or (`member_realname` LIKE '%测试%') or (`member_telephone` LIKE '%测试%'))