mysql like variable code example

Example: mysl like insert a variable

SET @email = '[email protected]';

SELECT email from `user` WHERE email LIKE CONCAT('%', @email, '%');