# Support for FTS and MATCH statements?

**URL:** https://discuss.tryton.org/t/support-for-fts-and-match-statements/5474
**Category:** Developer
**Tags:** python-sql
**Created:** [August 16, 2022, 11:42am UTC](https://discuss.tryton.org/t/support-for-fts-and-match-statements/5474 "2022-08-16T11:42:16Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![goruneta](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/g/46a35a/32.png) [@goruneta](https://discuss.tryton.org/u/goruneta)
#### Post date: [August 16, 2022, 11:42am UTC](https://discuss.tryton.org/t/support-for-fts-and-match-statements/5474/1 "2022-08-16T11:42:16Z")

</div>

Does `python-sql` have (or the possibility to have) functions/classes for statements unique to FTS (in SQLite)? Such as:

```sql
SELECT * FROM TableFTS WHERE TableFTS MATCH '...'

```

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [August 16, 2022, 11:58am UTC](https://discuss.tryton.org/t/support-for-fts-and-match-statements/5474/2 "2022-08-16T11:58:11Z")

</div>

`MATCH` is not a SQL standard operator. Indeed there is [`SIMILAR TO`](https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP) which is a TODO in sql/operators.py. It seems it can be implemented by using `REGEXP` operator for SQLite and MySQL.