sure, that's what escape does, pass it a character like escape='/'
http://docs.sqlalchemy.org/en/rel_0_8/core/expression_api.html#sqlalchemy.sql.operators.ColumnOperators.like
On Jan 27, 2013, at 2:14 AM, Joel Dunham wrote:
I know this discussion is 6 years old, but does SQLA now have support
I know this discussion is 6 years old, but does SQLA now have support for
ESCAPE clauses in SQLite LIKE queries? Is there some way I can achieve
this?
Thanks,
Joel
On Wednesday, April 4, 2007 10:43:56 AM UTC-7, Paul Kippes wrote:
I've been using sqlite and as far as I know, it requires
what is ESCAPE used for exactly (i.e. whats it going to do to that
\ ?) ? what DB is this ? can this same functionality be achieved via
bind parameters ?
On Apr 4, 2007, at 10:30 AM, Paul Kippes wrote:
Currently sqlalchemy doesn't support a query like this:
SELECT my_name FROM names
It permits escaping of the wild LIKE characters _ and %.
Say, for example, I have this column data:
1 larry_one
2 larry_two
3 larrysmall
4 larrybig
5 larry_small
6 larry_big
SELECT my_name FROM names WHERE my_name LIKE 'larry_%'
would return all the rows; but using
SELECT my_name FROM names
in postgres for example, \ is already the escape character, so you
wouldnt need to say ESCAPE '\'. is this not the case in DB2 (we dont
support DB2 anyway yet ?) ?
if you want to provide a patch, this would be a keyword argument to
the like() function, and would probably involve replacing
I've been using sqlite and as far as I know, it requires the ESCAPE clause.
I'll take a stab at creating a patch this evening.
On 4/4/07, Michael Bayer [EMAIL PROTECTED] wrote:
in postgres for example, \ is already the escape character, so you
wouldnt need to say ESCAPE '\'. is this not