LIKE missing in gadfly

Christophe Delarue cdelarue at bigfoot.com
Wed Oct 10 07:43:41 EDT 2001


I am quite new in SQL.

I make through a gfclient/gfserve a query resulting of a wilde result.

Right now, I reduce this result on the client side by using a regexp
on a
special field.  How could this be done on the server side ?

In the gadfly doc, the LIKE command is ommitted due to the ``re''
module in
python. All right, how could I implement this on the server side to
avoid too
many data to transit.

i.e. TABLE='FELLOWS'

FIRSTNAME  NAME
---------------
Bill       O'shea
Chris      El'Froggy

I'd like something  :

SELECT name FROM fellows WHERE name LIKE
NAME.match(re.compile("[A-Z]{2}'[A-Za-z]+"))

thank's



More information about the Python-list mailing list