🐛 Bug Report: Query not Working.

[AryanShah874]

👟 Reproduction steps

When I try to use Query.search('title', query) , it works for all the worlds except words having 'a' as a character.

👍 Expected behavior

It should be able to return data having title containing letter 'a' when I provide 'a' in the query.

👎 Actual Behavior

Empty

🎲 Appwrite version

Version 0.10.x

💻 Operating system

Windows

🧱 Your Environment

No response

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[stnguyen90]

@AryanShah874, thanks for creating this issue! 🙏🏼

If you're looking for text that contains a substring, you should use the Query.contains() query. See https://appwrite.io/docs/products/databases/queries.

The Query.search() query uses mariadb's full text search feature. You can read about how it works here.