Re: print records that match regexp

2008-01-29 Thread bbrecht56
On Jan 28, 6:11 pm, [EMAIL PROTECTED] (Chas. Owens) wrote: On Jan 28, 2008 4:12 PM, [EMAIL PROTECTED] wrote: I have a table customer_table with the following fields: Id int, firstname varchar(64), lastname varchar(64), emailaddress varchar(64) not null primary key city varchar

Re: print records that match regexp

2008-01-29 Thread Chas. Owens
On Jan 29, 2008 2:03 AM, [EMAIL PROTECTED] wrote: snip Sorry, I missed the ^ for the regexp ^A+ snip The ^ should only be used if you were to use Perl regexes, and even then your expression would not match anything but strings that held As (+ matches the last character 1 or more times). But

Re: print records that match regexp

2008-01-29 Thread bbrecht56
On Jan 29, 5:55 am, [EMAIL PROTECTED] (Chas. Owens) wrote: On Jan 29, 2008 2:03 AM, [EMAIL PROTECTED] wrote: snip Sorry, I missed the ^ for the regexp ^A+ snip The ^ should only be used if you were to use Perl regexes, and even then your expression would not match anything but strings that

print records that match regexp

2008-01-28 Thread bbrecht56
I have a table customer_table with the following fields: Id int, firstname varchar(64), lastname varchar(64), emailaddress varchar(64) not null primary key city varchar (32), Can some one help me and show me how to print only records that matches a given regexp using, for example if I run: #

Re: print records that match regexp

2008-01-28 Thread Chas. Owens
On Jan 28, 2008 4:12 PM, [EMAIL PROTECTED] wrote: I have a table customer_table with the following fields: Id int, firstname varchar(64), lastname varchar(64), emailaddress varchar(64) not null primary key city varchar (32), Can some one help me and show me how to print only records that