select * from user t where CONCAT( t.`user_name`, t.`real_name` ) LIKE CONCAT( '%', '路', '%' )
等同于下面sql语句,前提条件是user_name和real_name字段不能为空,否则统计的数据不全
select * from sys_user t where t.`user_name` LIKE CONCAT( '%', '路', '%' ) or t.`real_name` LIKE CONCAT( '%', '路', '%' )