>
>
>----------------------------------------------------------------------------------------
>
> And I've filled this with a bit of data. Well, more than a bit - 5,791,651 rows
>actually. Still, while this is large, it doesn't seem rediculously huge.
>
> Let's say I want to perform a query to select the last 22 days worth of closing
>prices for stock ABC. I run the query:
>
>
>----------------------------------------------------------------------------------------
> mysql> select close from shares where symbol='abc' and date < current_date() order
>by date desc limit 22;
>
>----------------------------------------------------------------------------------------
try this, it should help:
select close from shares where symbol like 'abc' and date < current_date()
order by date desc limit 22;
--- Sistemes - DRAC telemàtic ---------------------
David Diaz i Torrico
c/ Transversal 226 - 08225 Terrassa
Tel: +34 93 736 48 30
mailto:[EMAIL PROTECTED]
----------------------------------------------------
---------------------------------------------------------------------
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
