MySql WorkBench Syntax

Question

Can someone tell me what i am doing wrong below, I working in MySql workbench environment, this is killing me. My where clause is wrong, in Sql Server 2008 this would be right.


CREATE PROCEDURE `colordatabase`.`prc_GetTestInfoBycolorSerialNumber`
(
  IN    colorSerialNumber     VARCHAR (50)
)
BEGIN

SELECT    
        table1.colorSerialNumber,
        table1.colorPartNumber,
        table1.comments,
        table2.ID,
        table2.colorName,
        table2.colorCreationStartTime ,
        table2.colorOperator
       
    
FROM         table1     INNER JOIN
                              table2 ON seeker.colorPartNumber = table2.color_PartNumber AND
                              table1.colorSerialNumber = table2.color_SerialNumber                

WHERE    (table1.SerialNumber Like '' + @colorSerialNumber + '%');

END