I am using mysql server and want to write like query in sql stored procedure depending on input.
create procedure search(searchstring varchar(500))
BEGIN
Select im.* from Details im left join userrecords al on al.AccessLevelID = im.ImagePath where ImageName like '%'+searchstring+'%' || im.Description like '%' +searchstring+ '%' .
END
In '+' symbol its giving error.so how to write query.