Re: Formulating a query - rene - com.mysql.lists.win32

3 messages in com.mysql.lists.win32Re: Formulating a query

From	Sent On	Attachments
Corey Tisdale	17 Jan 2002 13:22
rene	17 Jan 2002 13:38
rene	17 Jan 2002 13:57

Subject:	Re: Formulating a query
From:	rene (teg...@dubaron.com)
Date:	01/17/2002 01:57:02 PM
List:	com.mysql.lists.win32

Hi,

sorry, didn't mean to be sarcastic but just noticed there were quite a few messages 'out of the book' like this, thought this was one of them; so i was interested in seeing if MySQL is tought at school nowadays; i agree i should haved asked that some more polite...

About the ODBC thing, maybe an extra index could help in your case, try to explain your table. A Numeric trick could work as well: ..where I<10000 order by abs(10000-I) limit 1 or something..

----- Original Message ----- From: "Corey Tisdale" <cor...@bbqguys.com> To: "rene" <teg...@dubaron.com> Sent: Thursday, January 17, 2002 10:46 PM Subject: Re: Formulating a query

Maybe I should have qualified my question a little more. Anything dealing

with several hundred records or more seems to run incredibly slowly when I use the MyODBC bridge. So, the idea was to formulate something where only the record less than 10000 was examined and returned. I was trying to avoid looking at everything less than 10000 then limiting the output. I realize that the less than sign is perfectly viable, but I thought for performance reasons (since I can't get myODBC to run speedily) that there may be some better way that I was overlooking. Please don't be offensive. I didn't realize that asking a question to a mailing list was worthy of such sarcasm. I hope you are treated with more repect should you ever ask something of this list.

-Corey

--- "rene" <teg...@dubaron.com> wrote:

select a from t where a<10000 order by a desc limit 1;

and/or by reading the amazing wonderfull manual:

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SE

ECT

which school/university are you on?

regards

----- Original Message ----- From: "Corey Tisdale" <cor...@bbqguys.com> To: <win...@lists.mysql.com> Sent: Thursday, January 17, 2002 10:22 PM Subject: Formulating a query

Say there is a table with a numeric column in it. There are some

numbers

less than 10000 and some greater than 10000 in this column. How would I write a slect statement to get the highest number that is less than 10000 out of this column?

MySQL for the spam filter.

Thanks, Corey Tisdale

_____________________________________________________________ http://www.bbqguys.com/ - free email (yo...@bbqguys.com), bbq forums, and the largest bbq superstore online!

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3...@lists.mysql.com instead.

_____________________________________________________________ http://www.bbqguys.com/ - free email (yo...@bbqguys.com), bbq forums, and

the largest bbq superstore online!