MySQL UNION function but with duplicates

Asked Aug 11 '20 at 11:51

Active Aug 11 '20 at 11:51

Viewed 27 times

Is there a function working like UNION on different SELECT statements that does not remove duplicates? Or any other way of creating one big column out of few smaller ones without loosing any data?

Example:

INPUT

col_1,    col_2,    
text1    text3        
text2    text2        
text3    text1

OUTPUT

col_3
text1
text2
text3
text3
text2
text1

asked Aug 11 '20 at 11:51

LeafBeads

5

use `UNION ALL` instead – fancyPants Aug 11 '20 at 11:52
If only someone thought to collate useful titbits like this into some kind of online resource. – Strawberry Aug 11 '20 at 14:02

MySQL UNION function but with duplicates

0 Answers0