Re: Select * except certain columns

2004-12-20 Thread Rhino
- Original Message - From: "Mark van 't Zet" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 20, 2004 6:59 AM Subject: Select * except certain columns > Hello, > > I was wondering if it's possible to select all fields

Select * except certain columns

2004-12-20 Thread Mark van 't Zet
Hello, I was wondering if it's possible to select all fields from a table except certain columns, e.g.: select * except text_name from text I have found several discussions on and outside the MySQL mailing lists that suggest it's not possible in (My)SQL. Why is this? It is a fe

Re: SELECT... EXCEPT FOR

2003-06-15 Thread Becoming Digital
cally. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: "Jed Hunsaker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, 14 June, 2003 22:03 Subject: SELECT... EXCEPT FOR If there's not a way to do this I would suggest

SELECT... EXCEPT FOR

2003-06-14 Thread Jed Hunsaker
If there's not a way to do this I would suggest it be added to the next version of MySQL, but has anyone ever heard of an "EXCEPT FOR" clause that can be used in MySQL's SELECT statements? For instance... "SELECT * FROM products EXCEPT FOR colors WHERE sizes LIKE '%small%'" Thanks... Jed Huns

Re: select except

2002-05-18 Thread Jason Englehardt
On Sun, 19 May 2002, Jule wrote: > Hey guys and gals, > > is there a query that selects all comuns from a table, except the one's i > have defined? > > Jule No, there isn't. It is safter if you name the columns you want. If you use a select * in your code instead of naming the particular column

select except

2002-05-18 Thread Jule
Hey guys and gals, is there a query that selects all comuns from a table, except the one's i have defined? Jule -- |\/\__/\/| | Jule Slootbeek | | [EMAIL PROTECTED]| | http://blindtheory.cjb.net | | __ | |/\/

Re: SELECT * EXCEPT field1, field2

2001-02-22 Thread Steve Ruby
Jack Dempsey wrote: > > Hi all, > > I'm wondering if it's possible to do something like that select line in > the subject...often i want to select * but not one or two fields...i > found something about this in the to do list for mysql4.0, but i'm > guessing that's not exactly what i'm thinking.

SELECT * EXCEPT field1, field2

2001-02-22 Thread Jack Dempsey
Hi all, I'm wondering if it's possible to do something like that select line in the subject...often i want to select * but not one or two fields...i found something about this in the to do list for mysql4.0, but i'm guessing that's not exactly what i'm thinking...is there an easy way to do this?