MySQL Forums
Forum List  »  InnoDB

Re: check constraint
Posted by: Peter Brawley
Date: November 15, 2008 11:09AM

> For (printing ) characters:

Not. For alphabetic characters:

select 'a' regexp '^([[:alpha:]]+)$'; -- returns 1
select ' a' regexp '^([[:alpha:]]+)$'; -- returns 0

PB
http://www.artfulsoftware.com

Options: ReplyQuote


Subject
Views
Written By
Posted
100468
May 09, 2007 01:54AM
39068
May 28, 2007 05:05PM
31263
June 07, 2007 07:31PM
27914
June 21, 2007 10:58PM
26130
June 28, 2007 03:02AM
24212
December 06, 2007 02:01PM
16773
October 15, 2008 04:08AM
16606
November 15, 2008 01:23AM
Re: check constraint
12170
November 15, 2008 11:09AM
18499
December 31, 2008 09:58AM
12693
January 06, 2009 03:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.