Re: Select all with an excpetion

2002-09-09 Thread Gerald Clark
I think the point of a question is to get the correct answer. The correct answer was given. David Lloyd wrote: Hmmm... Specify the fields you want in your query. example: SELECT stat_id, stat_name, stat_data FROM build_stats WHERE stat_date LIKE ... I think you miss the point of the

Select all with an excpetion

2002-09-07 Thread David Dillon
Hello, I am sorry if this is a painfully easy question, but I have been looking everywhere, and I cannot find out how to do what I need. My query is simply have: select * from table build_stats where stat_date like blah blah My only problem is that I dont want the field stat_date to

Re: Select all with an excpetion

2002-09-07 Thread olinux
Specify the fields you want in your query. example: SELECT stat_id, stat_name, stat_data FROM build_stats WHERE stat_date LIKE ... I would also recommend you pick up this book. It will save you hours and intro you to some simple but powerful SQL functions. Sams Teach Yourself SQL in 10 Minutes

Re: Select all with an excpetion

2002-09-07 Thread David Lloyd
Hmmm... Specify the fields you want in your query. example: SELECT stat_id, stat_name, stat_data FROM build_stats WHERE stat_date LIKE ... I think you miss the point of the question. What if you have table with 50 fields and you just don't want field 45, 46 and 48? It would be much