LIKE missing in gadfly
skip at pobox.com
Wed Oct 10 17:27:53 CEST 2001
Christophe> In the gadfly doc, the LIKE command is ommitted due to the
Christophe> ``re'' module in python. All right, how could I implement
Christophe> this on the server side to avoid too many data to transit.
Why not just add LIKE support to Gadfly? LIKE uses a very simple wildcard
scheme (at least in MySQL, where I use it). "%" is the same as ".*" in
regular expressions and "_" is the same as ".", so in the Gadfly code you
could (in theory) implement LIKE as a case-insensitive regular expression.
"%Dav_\%" would map to the regular expression "(?i).*Dav.%".
Skip Montanaro (skip at pobox.com)
More information about the Python-list