🐛 Bug Report: Query not Working.
Opened this issue · 1 comments
AryanShah874 commented
👟 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 commented
@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.