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