determine table in union statement

waqasahmed996

hi to all

i am using union in select statement like this

Expand|Select|Wrap|Line Numbers

 
mysql> SELECT * FROM t1 UNION SELECT * FROM t2 UNION SELECT * FROM t3;

please tell me that is it possible that i can check value is come from which table (t1,t2 or t3)

let me know if i am not clear in my question

waqasahmed996

i have done it by doing this

Expand|Select|Wrap|Line Numbers

 
SELECT 

    articles.id AS id,

    articles.title_article AS title,

    articles.contents AS contents,

    1 as tableid 

FROM articles 

WHERE 

    (articles.status = '1' 

        and (articles.title_article like '%political news%' or articles.contents LIKE '%political news%')

    ) 

UNION ALL 

SELECT 

    press_release.id,

    press_release.title,

    press_release.description,

    2 as tableid 

FROM press_release 

WHERE 

    (press_release.status = '1' 

        and (press_release.title like '%political news%' or press_release.author LIKE '%political news%' or press_release.description like '%political news%')

    ) 

UNION 

SELECT 

    latest_news.id,

    latest_news.title,

    latest_news.news,

    3 as tableid 

 FROM latest_news 

 WHERE 

    (latest_news.status = '1' 

        and (latest_news.title like '%political news%' or latest_news.news LIKE '%political news%')

    ) 

LIMIT 0, 50

Atli

Hi.

I'm glad you found a solution!
Thank you for sharing it with us.

determine table in union statement

re: determine table in union statement

re: determine table in union statement

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about