How to rewrite this Stored Procedure in MySQL?

[varshavmane]

Hi All, I have a working stored procedure which is on SQL Server 2005. Now I want to re-write this stored procedure in MYSQL. In SQL SERVER:

CREATE PROCEDURE [dbo].[Sp_GetCategory]
@prefixtext varchar(20)
AS
BEGIN
SET NOCOUNT ON;

select CategoryID,CategoryName from tb_Category_log WITH(NOLOCK) where CategoryName LIKE @prefixtext + '%'
END

Thanks in advance.