I have 2 stored procedures:
CREATE PROCEDURE `GetEntryCount`(param_Criteria VARCHAR(500))
BEGIN
IF (param_CRITERIA <> "") THEN
SET @QUERY1 = concat('SELECT user_name,count(*) as count
FROM foodmaster d inner join user_details u
on d.user_id=u.user_id WHERE (', param_CRITERIA ,') group by u.user_id;');
PREPARE stmt FROM @QUERY1;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END IF;
CREATE PROCEDURE `sample`(param_CRITERIA VARCHAR(500))
BEGIN
SELECT user_name,count(*) as count FROM foodmaster d
inner join user_details u on d.user_id=u.user_id
WHERE ( param_CRITERIA ) group by u.user_id;
END;
I tried with same param_criteria in both SPs. In the first procedure, i am getting results. But not in second. Why?