hi,

have you tried something like

SELECT surname, * FROM table WHERE surname LIKE '%brain'

regards