determine table in union statement

[waqasahmed996]

hi to all

i am using union in select statement like this

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

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.