Yes. I needed it to work as an operator in the form: FIELD REGEXP ".*",  not
regexp(FIELD,".*")
  

-----Original Message-----
From: Jay Sprenkle [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 10, 2005 10:32 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] REGEXP as an operator

On 5/10/05, John Buck <[EMAIL PROTECTED]> wrote:
> Greetings,
> 
> I am new to this list and the Sqlight project.
> 
> I ran across it while doing research on locating an alternative to the
Mysql
> Embedded engine.  Sqlite seems like it will do the trick with a few
tweaks.
> I just wanted to share one of those tweaks for comment.
> 
> One problem I ran into was I had used REGEXP as an operator throughout
> hundreds of lines of SQL.
> 
> So with a little work I added REGEXP as an operator to Sqlite 3.21.
> You can download the change for a limited time from
> municipal-software.com/Sqlite3.21REGEXP.zip

I guess you added it to the code directly and didn't create your own
function?


Reply via email to