From 7790425a993480e81605efc8a07fed13bcdd4841 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Mon, 28 Jan 2013 13:58:01 -0500 Subject: [PATCH] - add full docs for like()/ilike() --- lib/sqlalchemy/sql/operators.py | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) diff --git a/lib/sqlalchemy/sql/operators.py b/lib/sqlalchemy/sql/operators.py index f233bf0fb7..10d01acd62 100644 --- a/lib/sqlalchemy/sql/operators.py +++ b/lib/sqlalchemy/sql/operators.py @@ -356,6 +356,20 @@ class ColumnOperators(Operators): In a column context, produces the clause ``a LIKE other``. + E.g.:: + + select([sometable]).where(sometable.c.column.like("%foobar%")) + + :param other: expression to be compared + :param escape: optional escape character, renders the ``ESCAPE`` + keyword, e.g.:: + + somecolumn.like("foo/%bar", escape="/") + + .. seealso:: + + :meth:`.ColumnOperators.ilike` + """ return self.operate(like_op, other, escape=escape) @@ -364,6 +378,20 @@ class ColumnOperators(Operators): In a column context, produces the clause ``a ILIKE other``. + E.g.:: + + select([sometable]).where(sometable.c.column.ilike("%foobar%")) + + :param other: expression to be compared + :param escape: optional escape character, renders the ``ESCAPE`` + keyword, e.g.:: + + somecolumn.ilike("foo/%bar", escape="/") + + .. seealso:: + + :meth:`.ColumnOperators.like` + """ return self.operate(ilike_op, other, escape=escape) -- 2.47.2