Il faut utiliser le catalogue :


select count(*)
from information_schema.columns
where table_schema = 'ta_database'
and table_name = 'ta_table'
and column_name like 'quest\_%'