Re: Help querying a simple but large table

["James Blackwell" <jamesb@xxxxxxx>]

Is like that much faster than =?  If so, this would be a good thing to know.  I'm assuming that not putting a % either before or after the variable would make it the equivilent of an =.

Can you possibly point me somewhere that explains this a bit or possibly gives some kind of benchmarks?

Thanks for the info, always good to learn new ideas!
--James

-----------------------
From your message of Thu, 15 Mar 2001 15:57:15 +0100 (CET):

>
> ----------------------------------------------------------------------------------------
>
> 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:
>
> ----------------------------------------------------------------------------------------
> 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:david@xxxxxxxx
>----------------------------------------------------
>---------------------------------------------------------------------
>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 <mysql-thread68335@xxxxxxxxxxxxxxx>
>To unsubscribe, e-mail <mysql-unsubscribe-jamesb=lsg.net@xxxxxxxxxxxxxxx>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>






---------------------------------------------------------------------
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 <mysql-thread68355@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php