uses the Unix file globbing *** syntax *** It is the SYNTAX that it uses, not the UNIX FILE GLOBBING =)
On 2/1/10, Oliver Peters <oliver....@web.de> wrote: > 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 [...] uses the Unix file globbing syntax for its > wildcards." > > But the reason might be that I usually don't use Linux for shell > operations because in the office I've to use WinXP. Maybe someone could > replenish the documentation with a few examples for the disadvantaged MS > users? > > Oliver > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- [] Júlio César Ködel G. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users