You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ZYAH%' ) order by `position` asc' at line 1

SQL:
select * from `webberz_results` where `rid`='1964' and ( `id`<>'' AND `surname` like '%CHARLES%' AND `firstname` like '%K'ZYAH%' ) order by `position` asc