-- search the full and intro text in articles and categories
select ty, id, state, title
from (select "art" ty, id, state, title, concat(introtext, " <full> ", `fulltext`) text from spWaJ34_content
union all select "cat", id, 0, title, description from spWaJ34_categories) t
where text like "%ungGV%";