ޠjSSKJr SSKJr SSKJr SSKJr SSKJr SSKJ r SSKJ r SS KJ r SS K J r SS K Jr SS KJr "S S\\ R"\5rg)) annotations)Any)exc)util) coercions)elements) operators)roles) _generative) Generative)Selfc^\rSrSr%SrSrSrS\S'S U4Sjjr\ S Sj5r \ S S j5r \ S S j5r S r U=r$)matchaProduce a ``MATCH (X, Y) AGAINST ('TEXT')`` clause. E.g.:: from sqlalchemy import desc from sqlalchemy.dialects.mysql import match match_expr = match( users_table.c.firstname, users_table.c.lastname, against="Firstname Lastname", ) stmt = ( select(users_table) .where(match_expr.in_boolean_mode()) .order_by(desc(match_expr)) ) Would produce SQL resembling: .. sourcecode:: sql SELECT id, firstname, lastname FROM user WHERE MATCH(firstname, lastname) AGAINST (:param_1 IN BOOLEAN MODE) ORDER BY MATCH(firstname, lastname) AGAINST (:param_2) DESC The :func:`_mysql.match` function is a standalone version of the :meth:`_sql.ColumnElement.match` method available on all SQL expressions, as when :meth:`_expression.ColumnElement.match` is used, but allows to pass multiple columns :param cols: column expressions to match against :param against: expression to be compared towards :param in_boolean_mode: boolean, set "boolean mode" to true :param in_natural_language_mode: boolean , set "natural language" to true :param with_query_expansion: boolean, set "query expansion" to true .. versionadded:: 1.4.19 .. seealso:: :meth:`_expression.ColumnElement.match` mysql_matchTzutil.immutabledict[str, Any] modifierscr>U(d[R"S5eURSS5nUc[R"S5e[R"[ R U5n[RR[RUS9nSUl [R"URSS5URSS5URSS5S .5nU(a([R"S S RU5-5e[ TU]EXC[R$US 9 g) Nzcolumns are requiredagainstzagainst is required)clausesFin_boolean_modein_natural_language_modewith_query_expansion)mysql_boolean_modemysql_natural_languagemysql_query_expansionzunknown arguments: %sz, r)r ArgumentErrorpoprexpectr ExpressionElementRoler BooleanClauseList_construct_rawr comma_opgroupr immutabledictjoinsuper__init__match_op)selfcolskwrleftflags __class__s ^/var/www/html/gaurav/venv/lib/python3.13/site-packages/sqlalchemy/dialects/mysql/expression.pyr)match.__init__Ps##$:; ;&&D) ?##$9: :""  ' '   ))88   9  ""&(ff->&F*,&&.+*,0F)N    ##$;tyy}$MN N  (:(:eLcJURRSS05UlU$)zApply the "IN BOOLEAN MODE" modifier to the MATCH expression. :return: a new :class:`_mysql.match` instance with modifications applied. rTrunionr+s r1rmatch.in_boolean_moders%--/CT.JK r3cJURRSS05UlU$)zApply the "IN NATURAL LANGUAGE MODE" modifier to the MATCH expression. :return: a new :class:`_mysql.match` instance with modifications applied. rTr5r7s r1rmatch.in_natural_language_mode}s%--/G.NO r3cJURRSS05UlU$)zApply the "WITH QUERY EXPANSION" modifier to the MATCH expression. :return: a new :class:`_mysql.match` instance with modifications applied. rTr5r7s r1rmatch.with_query_expansions%--/F.MN r3r)r,zelements.ColumnElement[Any]r-r)returnr)__name__ __module__ __qualname____firstlineno____doc____visit_name__ inherit_cache__annotations__r)r rrr__static_attributes__ __classcell__)r0s@r1rrs^1f#NM++ MD  r3rN) __future__rtypingrrrsqlrr r r sql.baser r util.typingrBinaryExpressionrr3r1rPsC##"{J11#6{r3