Mysql concat not working


#1

BEGIN
declare xyz text;
SET xyz = ‘’;
IF pminPrice IS NULL AND pmaxPrice IS NOT NULL THEN
SET xyz = concat(xyz, Rent = pmaxPrice);
END IF;
SELECT * FROM listing WHERE xyz;
END

RESULT:- BLANK

Can Anyone help me out