Re: variables in WHERE

[Federico Razzoli]

I guess you are trying to search the string 'won'.

create procedure find_council(IN txtin VARCAHR(50))
begin
set txtin = concat('%',txtin,'%');
select * from council where 'Council Name' like txtin;
end

CALL FIND_COUNCIL ('won');

Without ' you are trying to pass a column to the procedure, but the column `won` does not exist.