--- Hunter Hillegas <lists(at)lastonepicked(dot)com> wrote:
> Is there a way to select all rows where a certain
> column starts with
> non-alpha characters?
> I would like to select all the rows that don't start
> with letters.
Regular expressions would do what you want, e.g.
"select * from mytable where myfield !~ '^[a-zA-Z]';"
Look under "pattern matching" in the "functions and
operators" section of the manual (I think, working
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
In response to
pgsql-general by date
|Next:||From: B. van Ouwerkerk||Date: 2003-12-29 23:24:47|
|Subject: Re: Is my MySQL Gaining ? |
|Previous:||From: Jeff Eckermann||Date: 2003-12-29 23:18:46|
|Subject: Re: [pgsql-advocacy] Is my MySQL Gaining ?|