테이블이 여러개 있습니다...
전체 검색을 할 때 테이블명도 같이 리스트로 뽑을 수 있을까요?
select * from
(select id,title,name,content,date,cnt from table_a
where (name like '%$search%') or (title like '%$search%') or (content like '%$search%')
order by id desc limit $limit offset $positionx) a
UNION ALL
select * from
(select id,title,name,content,date,cnt from table_b
where (name like '%$search%') or (title like '%$search%') or (content like '%$search%')
order by id desc limit $limit offset $positionx) a
table_a id title name content date cnt
table_b id title name content date cnt
table_a id title name content date cnt
table_a id title name content date cnt
table_b id title name content date cnt
이런식으로....
|