Re: [sqlite] Using LIKE to check the first digits?

[Gilles]

At 02:01 01/02/2008 +0000, [EMAIL PROTECTED] wrote:

Indices won't help with LIKE unless the column as a NOCASE collation. Use GLOB instead:

  ... WHERE number GLOB '1234*';

Thank you for the tip.


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------