Question

why '%' used in mysql?

Answer 1

% it means percentage sign in maths

% modulus sign in comp

Hope it helps u^_^

Answer 2

ANSWER____✍️✔️

START

SET @emailid= CONCAT('%', '[email protected]', '%');

SET @t1 = CONCAT('SELECT * FROM user WHERE email LIKE ' ' ' , @emailid, ' ' ');

PREPARE stmt3 FROM @t1;

EXECUTE stmt3;

DEALLOCATE PREPARE stmt3;

END

MARK BRAINLIEST✓✓⚜️