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 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 easier to use an except clause here rather than have to specify 47 fields... DSL (this mysql query spam filter is spam) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 show up in the results. Is there any such thing like and except clause or something along those lines. Even if someone could point me in the direction of a good resource where I might be able to find it, that would be much appreciated. Thank you very much for your time. -Dave- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 http://www.amazon.com/exec/obidos/tg/detail/-/0672321289/102-8456958-9824163 olinux --- David Dillon [EMAIL PROTECTED] wrote: 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 show up in the results. Is there any such thing like and except clause or something along those lines. Even if someone could point me in the direction of a good resource where I might be able to find it, that would be much appreciated. Thank you very much for your time. -Dave- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 easier to use an except clause here rather than have to specify 47 fields... DSL (this mysql query spam filter is spam) -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php