Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

2010-02-01 Thread Jay A. Kreibich
On Tue, Feb 02, 2010 at 12:55:34AM +0100, Oliver Peters scratched on the wall: > Am Montag, den 01.02.2010, 22:55 +0100 schrieb Jean-Christophe > Deschamps: > > [...] > > > > Try this: > > > > SELECT * FROM mytable WHERE myfield glob '[0-9]*' > > thank you for opening my eyes - it seems that I

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

2010-02-01 Thread Júlio César Ködel
uses the Unix file globbing *** syntax *** It is the SYNTAX that it uses, not the UNIX FILE GLOBBING =) On 2/1/10, Oliver Peters wrote: > Am Montag, den 01.02.2010, 22:55 +0100 schrieb Jean-Christophe > Deschamps: > > [...] >> >> Try this: >> >> SELECT * FROM mytable WHERE myfield glob '[0-9]*'

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

2010-02-01 Thread Oliver Peters
Am Montag, den 01.02.2010, 22:55 +0100 schrieb Jean-Christophe Deschamps: [...] > > Try this: > > SELECT * FROM mytable WHERE myfield glob '[0-9]*' > thank you for opening my eyes - it seems that I never read http://www.sqlite.org/lang_expr.html#glob with total awareness. "The GLOB operator

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

2010-02-01 Thread Simon Slavin
On 1 Feb 2010, at 9:49pm, flakpit wrote: > To to get columns that begin with a number range or any number, I would use > in SQL server: > > SELECT * FROM mytable WHERE myfield LIKE '[0-9]%' > > This obviously doesn't work in sqlite and I have been searching for an > equivalence. SELECT * FROM

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

2010-02-01 Thread flakpit
flakpit wrote: > > To to get columns that begin with a number range or any number, I would > use in SQL server: > > SELECT * FROM mytable WHERE myfield LIKE '[0-9]%' > > This obviously doesn't work in sqlite and I have been searching for an > equivalence. > Thank you for your kind assistanc

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

2010-02-01 Thread Jay A. Kreibich
On Mon, Feb 01, 2010 at 01:49:59PM -0800, flakpit scratched on the wall: > > To to get columns that begin with a number range or any number, I would use > in SQL server: > > SELECT * FROM mytable WHERE myfield LIKE '[0-9]%' Use "...WHERE myfield GLOB '[0-9]*' " -j -- Jay A. Kreibich <

Re: [sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

2010-02-01 Thread Jean-Christophe Deschamps
>To to get columns that begin with a number range or any number, I >would use >in SQL server: > >SELECT * FROM mytable WHERE myfield LIKE '[0-9]%' > >This obviously doesn't work in sqlite and I have been searching for an >equivalence. Try this: SELECT * FROM mytable WHERE myfield glob '[0-9]*'

[sqlite] Searching for a LIKE '[0-9]%' equivalence in sqlite

2010-02-01 Thread flakpit
To to get columns that begin with a number range or any number, I would use in SQL server: SELECT * FROM mytable WHERE myfield LIKE '[0-9]%' This obviously doesn't work in sqlite and I have been searching for an equivalence. -- View this message in context: http://old.nabble.com/Searching-for-