SQLize Online / PHPize Online  /  SQLtest Online

create table t1 (id int, referer text); create table t2 (id int, referer text); create table t3 (id int, referer text); insert into t1 values (1, 'test'), (2, 'http://yandex.ru'); insert into t2 values (10, 'test'), (20, 'www.yandex.ru'); insert into t3 values (100, 'test'), (200, 'yandex.ru/pictures'); SELECT GROUP_CONCAT('select referer from ' || name || ' where referer like "%yandex%"', ' union ') q FROM sqlite_master WHERE type ='table' AND name NOT LIKE 'sqlite_%'; select referer from t1 where referer like "%yandex%" union select referer from t2 where referer like "%yandex%";