variables in WHERE

[Eric Dropps]

Hello, I need some help here, i've tried a bunch of things but i'm stuck!

for some reson this code below always returns:

mysql> CALL FIND_COUNCIL (won);
ERROR 1054 (42S22): Unknown column 'won' in 'order clause'

CREATE PROCEDURE `campnet`.`Find_Council`(IN txtin VARCHAR(50) )
SELECT *
FROM `council`
WHERE `Council Name` LIKE CONCAT('%',"txtin",'%');


the query works fine by itself, but not inside the procedure (i assue it's due to the fact i need to put % on both sides of the variable.

Any help appriciated!