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