like模糊查询要拼接%的时候,用这个函数CONCAT( ‘%’, ‘王’, ‘%’ )
SELECT
id,
user_name,
pass_word,
create_by,
create_date,
update_by,
update_date
FROM
test_mysql.`user`
WHERE
(
user_name LIKE CONCAT( '%', '王', '%' )
OR pass_word LIKE CONCAT( '%', '234', '%' )
)