Accessing multiple columns with different numbers?

Discussion in 'MySQL' started by Miquexia, Aug 28, 2010.

0
  1. #1
    Hello,

    I have a table with a few columns called field0, field1, field2, field3, etc. which i'd like to pull data from.

    Is there a possibility to make a query something like SELECT field* FROM `table` ( with * selecting a random number automatically ) otherwise i'd have to select each one of them ( SELECT field0, field1, field2, field3) which would result in a very long query.

    Can anyone help me out with this one?

    Thanks.
     
    Miquexia, Aug 28, 2010 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    No, it is not possible. If you are SELECTing most of the columns then you can also use SELECT * from table name.
     
    mwasif, Aug 28, 2010 IP