+ }j^RIHt^RIHt^RIHt^RIHt^RIHt^RIH t ^RIH t ^RIH t ^R I H t ^R I Ht^R IHt!R R ]] P"],4tR#)) annotations)Any)exc)util) coercions)elements) operators)roles) _generative) Generative)Selfca]tRt^t$RtRtRtR]R&RV3Rllt] RR l4t ] R R l4t ] R R l4t Rt V;t#)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] modifiersc V^8dQhRRRR/#)colszelements.ColumnElement[Any]kwr)formats"e/home/luca/screen-checking/.venv/lib/python3.14/site-packages/sqlalchemy/dialects/mysql/expression.py __annotate__match.__annotate__Ps M M9 M Mc  <V'g\P!R4hVPRR4pVf\P!R4h\P!\ P V4p\PP\PVR7pRVn \P!RVPRR4RVPR R4R VPR R4/4pV'd-\P!R R PV4,4h\ SV`EWC\P$VR7R#)zcolumns are requiredagainstNzagainst is required)clausesFmysql_boolean_modein_boolean_modemysql_natural_languagein_natural_language_modemysql_query_expansionwith_query_expansionzunknown arguments: %sz, r)r ArgumentErrorpoprexpectr ExpressionElementRolerBooleanClauseList_construct_rawr comma_opgroupr immutabledictjoinsuper__init__match_op)selfrrrleftflags __class__s&*, rr1match.__init__Ps##$:; ;&&D) ?##$9: :""  ' '   ))88   9  ""$bff->&F("&&.+(0F)N    ##$;tyy}$MN N  (:(:eLrcV^8dQhRR/#rreturnr r)rs"rrrssrc JVPPRR/4VnV#)zApply the "IN BOOLEAN MODE" modifier to the MATCH expression. :return: a new :class:`_mysql.match` instance with modifications applied. rTrunionr3s&rr match.in_boolean_moders%--/CT.JK rcV^8dQhRR/#r9r)rs"rrr~s  $ rc JVPPRR/4VnV#)zApply the "IN NATURAL LANGUAGE MODE" modifier to the MATCH expression. :return: a new :class:`_mysql.match` instance with modifications applied. r!Tr<r>s&rr"match.in_natural_language_mode}s%--/G.NO rcV^8dQhRR/#r9r)rs"rrrsdrc JVPPRR/4VnV#)zApply the "WITH QUERY EXPANSION" modifier to the MATCH expression. :return: a new :class:`_mysql.match` instance with modifications applied. r#Tr<r>s&rr$match.with_query_expansions%--/F.MN rr%)__name__ __module__ __qualname____firstlineno____doc____visit_name__ inherit_cache__annotations__r1r r r"r$__static_attributes__ __classcell__)r6s@rrrsd1f#NM++ M MD  rrN) __future__rtypingrrrsqlrrr r sql.baser r util.typingr BinaryExpressionrrrrrWsC##"{J11#6{r