Python sqlite and regex.

[Dan Sommers]

On Fri, 19 May 2006 17:44:45 GMT,
"Paul McGuire" <ptmcg at austin.rr._bogus_.com> wrote:

> "Gerhard Häring" <gh at ghaering.de> wrote in message
> news:mailman.5966.1148057291.27775.python-list at python.org...

>> """
>> The REGEXP operator is a special syntax for the regexp() user
>> function. No regexp() user function is defined by default and so use
>> of the REGEXP operator will normally result in an error message. If a
>> user-defined function named "regexp" is defined at run-time, that
>> function will be called in order to implement the REGEXP operator.
>> """

> This is very interesting.  So I *could* define my own regexp function
> that processes not regular expressions, but say, glob-like strings,
> which are usually much easier for end users to work with (very basic
> wild-carding where '*' matches one or more characters, and '?' matches
> any single character - maybe add '#' to match any single digit and '@'
> to match any single alpha character).

Doesn't SQL already have lightweight wildcards?

    SELECT somefield FROM sometable WHERE someotherfield LIKE '%foo%'

Regards,
Dan

-- 
Dan Sommers
<http://www.tombstonezero.net/dan/>
"I wish people would die in alphabetical order." -- My wife, the genealogist