Parameters for table, field and searchValue

[Russel James]

Hi Folks,

Im trying to create a sproc that will return 1 or 0 if a searchValue is found within a specified field within a specified table.

Something like...

CREATE DEFINER=`root`@`localhost` PROCEDURE `usp_CheckIfValueExists`(IN p_tbl varchar(50), IN p_fld varchar(50), IN p_searchValue varchar(50))
BEGIN

SELECT EXISTS(SELECT 1 FROM p_tbl WHERE p_fld = p_searchValue);

END

But it just not working.

Can I not use parameters on the left side of a Where clause ??

J