Re: Select all with an excpetion

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 poi

Re: Select all with an excpetion

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 e

Re: Select all with an excpetion

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

Select all with an excpetion

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 sho