In PHP it's very easy to create user defined functions. Just look in manual:
http://lv2.php.net/manual/en/function.sqlite-create-function.php
There you can find an example how to create sort of md5 function in SQLite as a 
callback.
In similar way you can in very simple way create preg_match/ereg funcion 
callbacks.

--
Martins

From: Win a 2 [EMAIL PROTECTED]
Date: Mon, 28 Mar 2005 21:01:33 +0300
To: Cariotoglou Mike [email protected]
Subject: Re: [sqlite] RegEx w/ sqlite, yet?

> Hello Cariotoglou,
> 
> Monday, March 28, 2005, 7:23:23 AM, you wrote:
> 
> > If you are working with delphi, I could have a solution for you. 
> 
> >> -----Original Message-----
> >> From: Jay [mailto:[EMAIL PROTECTED] 
> >> Sent: Saturday, March 26, 2005 3:41 AM
> >> To: [email protected]; Win a 2
> >> Subject: Re: [sqlite] RegEx w/ sqlite, yet?
> >> 
> >> 
> >> > Hello sqlite-users,
> >> > 
> >> >   any news on that?
> >> 
> >> It's not part of the sql standard, so I would bet the answer 
> >> is going to be 'you have to add that yourself'. I did for my project.
> >> 
> 
> No, I'm working with PHP.
> I'm actually thinking about reading the data fields and to parse them
> via PHP-regex.
> But if it could be completly done in sqlite it would be better.
> 
> -- 
> bye,
>  -=winne=-                            mailto:[EMAIL PROTECTED]
> 

Reply via email to