dimanche 4 juin 2017

MySQL Select * but exclude columns that are equal to 0

I have a a table with a lot of column like this which are tinyint(1) with 0 or 1 as value:

    `size_20x20`
    `size_24x18`
    `size_25x20`
    `size_25x25`
    `size_30x24`
    `size_30x30`
    `size_40x20`
    `size_40x30`
    `size_40x40`
    `size_50x25`
    `size_50x40`
...

I would like to do a SELECT * FROM mytable WHERE id = 9 but exclude columns with value 0. Is it possible?

Aucun commentaire:

Enregistrer un commentaire