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
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