Providing MySQL a manually-typed list of rows to left join with? -


My Google-Fu is weak on this, so maybe you can help all.

If you want to select multiple columns, you can ...

Select 'Something' as the Username, 'Fobar' as normal By form

And you will get:

  + ---------------- + ---- ------------- + | Username General sentence + ---------------- + ----------------- + | Some | FuBar | + ---------------- + ----------------- +   

However, how What do I do with the lines mentioned above?

EG:

  Select some row, leave it from efy.text table (select 'a' as UNION 'b' UNION 'C'). To get results such as effy   

edit: ..

  + ------ - --------- + -------------- + | Some lines Effy.text | + ---------------- + -------------- + | Entry A | One | | Entry A | B | Entry A | C. + ---------------- + -------------- +    

You were almost there:

  Select some lines, connect table to left. Text (select text as 'A' UNICE ALL selection 'B' union select all 'C') as effy    

Comments