SELECT stuff FROM db1.t WHERE stuff like 'foo%'
    UNION
    SELECT stuff FROM db2.t WHERE stuff like 'foo%'
    UNION
    SELECT stuff FROM db3.t WHERE stuff like 'foo%'