search

kayak / pypika

PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
http://pypika.readthedocs.io/en/latest/
Apache License 2.0
2.43k stars 292 forks source link

How to use pypika to implement the 'MATCH AGAINST' statement for full-text search queries #770

Open fanliugen opened 7 months ago

fanliugen commented 7 months ago

Using pypika to access a MySQL database, there is a table in the database that utilizes full-text indexing. How can I use pypika to implement the 'MATCH AGAINST' statement for full-text search queries?

wd60622 commented 7 months ago

Doesnt seem implemented but seems possible with the building blocks currently in the terms.py It might have a similar implementation as the analytic functions. Maybe that source code could be helpful