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