Copy same select mysql query

Asked Nov 25 '15 at 12:51

Active Nov 25 '15 at 14:13

Viewed 44 times

I have this query:

        SELECT 
             concat(b.Name, " -FirstName") as Name                
        FROM table b
        UNION 
        SELECT 
             concat(b.Name, " -SecondName") as Name                
        FROM table b

The result is :

Frank -FirstName, Frank -SecondName

This works fine, but i think that could exist another way to do this without union.

Edit: I need two rows with different results from same field value.

Row1 = Frank -FirstName
Row2 = Frank -SecondName

Edit2: I can't change the BD too much. I will work with a unique row. Thanks to all!

edited Nov 25 '15 at 14:13

asked Nov 25 '15 at 12:51

Jm.ortega

What exactly output required for example? – Muhammad Muazzam Nov 25 '15 at 13:04
@MuhammadMuazzam `Frank -FirstName, Frank -SecondName` – Pathik Vejani Nov 25 '15 at 13:05
Its non-sense, no one need repeatition – Muhammad Muazzam Nov 25 '15 at 13:07
I need two rows with diferent results. – Jm.ortega Nov 25 '15 at 13:07
thats wrong as in same row – Muhammad Muazzam Nov 25 '15 at 13:10
yes.. i see the edited post just now. i deleted my answer – Pathik Vejani Nov 25 '15 at 13:11
2

@Jm.ortega Hope you don't mind, but why do you need the same field (name) as firstname and second name each? (though thinking about possibilities I couldn't think about any probable use cases for such a usage) – Thomas Nov 25 '15 at 13:17
I think you should focus more on database design than trying to work with this. Possible, yes. Worth it, probably not. – MrMarlow Nov 25 '15 at 13:17
Possible duplicate of [SQL split values to multiple rows](http://stackoverflow.com/questions/17942508/sql-split-values-to-multiple-rows) – Muhammad Muazzam Nov 25 '15 at 13:18
@MuhammadMuazzam not sure one can see it as a duplicate of that. The one question has multiple values in one field. Here he wants to duplicate each and every line. So even though the current question here does not make much sense to me I don't see there anything in the direction of duplicitism. – Thomas Nov 25 '15 at 13:30
Even if there's a good reason to repeat data like this, why would you want to do it without `UNION`? Why make it complicated? – fancyPants Nov 25 '15 at 14:11

Copy same select mysql query

0 Answers0