How to do this

[Firass Arrami]

Hi

I am trying to create a procedure where the result is based on the passed parameters
for example

CREATE DEFINER = 'root'@'localhost' PROCEDURE TelOwener(IN fField VARCHAR(25), IN Number VARCHAR(25), OUT CName VARCHAR(75))
BEGIN
SELECT Contact_Name into CName FROM TBL_ADRSBOOK WHERE fField = Number
END;

my programm will call this with diffrent field name like 'tel01_number' or 'tel02_number'


How can i do this

BR