[SOLVED] How to get Query. Search to consider spaces.

Hi, I'm using the search query and it's all working but I'm having trouble searching for names which include a space. Searching for Player 1 will show all player ( 1, 2, 3 etc) how do I make player one only show player 1, player 2 only show player 2 etc

maybe you can try searching for "player 1" instead of player 1 (wrap with double quotes).

If that doesn't work, there might not be anything else that can be done because the word "1" is too short and is ignored from mariadb's search index.

For more info on how the search works, check out https://github.com/appwrite/appwrite/discussions/5005#discussioncomment-4681079

That was just an example but it's ignoring everything after the space no matter the length

Search.select recognises spaces but it only returns names if its an exact full match, so entering bilal will so no results which is also not what I want

"letters, digits, and underscores" perhaps it isn't meant to index spaces

I've managed to resolve it Steve by looping the query for each word

Perhaps take note if anyone else runs into this issue as there's a simple solution, thanks for your help 👌

[SOLVED] How to get Query. Search to consider spaces.