How to use a user variables in MySQL LIKE clause? March 28, 2023 by Tarik SET @email="test@test.com"; SELECT email from `user` WHERE email LIKE CONCAT('%', @email, '%');