How to select and play values in the same column

Asked

Viewed 51 times

2

Example:

select 'a' as 'letras', 'b' as 'letras'

I want to play the letter 'a' and the letter 'b' in the column 'letters', but with this code it returns 2 columns with the same name, but I want to play the values in the same column and I don’t know how to do this or how to search.

mysql sql database

1 answer

3


An alternative is the UNION :

select 'a' as letras

union

select 'b'
  • 1

    Thanks! This UNION has helped me a lot in the generations of reports with a few thousand lines rs

Browser other questions tagged mysql sql database

You are not signed in. Login or sign up in order to post.