LIKE的用法:
like 后面可以根据列值来匹配。
思路:
like CONCAT('%','${phoneNumber}','%' )
SELECT
*
FROM
test
WHERE
phoneNumber LIKE phoneNumber
LIKE的用法:
like 后面可以根据列值来匹配。
思路:
like CONCAT('%','${phoneNumber}','%' )
SELECT
*
FROM
test
WHERE
phoneNumber LIKE phoneNumber