Re: Please Help Need Search Stored Proc

[John Gilmour]

Hi Peter,

Thanks again...as you can tell, I'm a newbie but they kicked this post out of the newbie forum :) Thanks again for all your help. Unfortunately I keep getting this error message...


#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@sql = CONCAT(@sql,' AND car.doors LIKE ',char(39),'%',mydoors,'%',char(39));
END IF;
' at line 15

Please help...we could be sooo close:)