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:[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
>
>
---------------------------------------------------------------------
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