From: Daevid Vincent Date: April 11 2003 12:38am Subject: Is there a way to select * MINUS some fields? List-Archive: http://lists.mysql.com/mysql/136959 Message-Id: <001501c2ffc2$a9589b90$a50aa8c0@Locutus> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Using the mysql command line frequently, it's often easy to type "SELECT = * FROM..." but when I have fields that are TEXT or larger, that is just = messy. Is there a way to omit some fields from the * selection? Basically I = don't want to list out 10 or 20 fields just to omit that 21st TEXT field...