Using Stored Procedure to search for records

[Aldrick]

Hi all,

Need some advice here. I am using MySQL Stored Procedures to do a search query. It seems that the query statement that I used is not proper, can advice on how to use it effectively?

CREATE PROCEDURE mysql_biosys.search_site(site_Name_Searched VARCHAR(64))
BEGIN
SELECT site_Name
FROM site
WHERE site_Name LIKE '%site_Name_Searched%'
AND site_Id != 1;
END;
|

Thanks.

regards,
Aldrick