MySQL: selecting all but one field?

Posted by gsquare567 on Stack Overflow See other posts from Stack Overflow or by gsquare567
Published on 2010-06-11T20:21:04Z Indexed on 2010/06/11 20:22 UTC
Read the original article Hit count: 250

Filed under:
|

instead of SELECT * FROM mytable, i would like to select all fields EXCEPT one (namely, the 'serialized' field, which stores a serialized object). this is because i think that losing that field will speed up my query by a lot. however, i have so many fields and am quite the lazy guy. is there a way to say...

`SELECT ALL_ROWS_EXCEPT(serialized) FROM mytable`

?

thanks!

© Stack Overflow or respective owner

Related posts about mysql

Related posts about mysql-select