mysql - Select specific rows and columns from an SQL database

Question

Is it possible to retrieve specific columns of specific rows in an SQL query?

Let's say I'm selecting from my SQL table, called my_table, rows whose names are: a, b, using this query text:

"select * from my_table where row_names in ('a', 'b') order by row_names"

How can I modify this query text to select only columns 2,12,22,32,42 rather all its 1000 columns?

Answer 1

Replace the wildcard symbol * with the column names you want to retrieve.

But please read up the documentation on SQL standard. It is very unlikely you need 1.000 columns in a table.