PROCEDURE MSSQL TO MYSQL

[ELTON BRITO EEE]

Good afternoon!
I would like help to perform the conversion of a procedure in Microsoft SQL to Mysql, because I am not succeeding.
-------------------------------------------
CREATE PROCEDURE [dbo]. [GetCustomers_Pager]
@SearchTerm VARCHAR (100) = ''
, @ PageIndex INT = 1
, @ PageSize INT = 10
, @ RecordCount INT OUTPUT
AT
BEGIN
SET NOCOUNT ON;
SELECT ROW_NUMBER () OVER
(
ORDER BY [CustomerID] ASC
) AS RowNumber
, [CustomerID]
, [CompanyName]
, [ContactName]
, [City]
INTO #Results
FROM [Customers]
WHERE [ContactName] LIKE @SearchTerm + '%' OR @SearchTerm = ''
SELECT @RecordCount = COUNT (*)
FROM #Results

SELECT * FROM #Results
WHERE RowNumber BETWEEN (@PageIndex -1) * @PageSize + 1 AND (((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

DROP TABLE #Results
END
-------------------------------------------------- ------

Thank you!