Fix sqlite

1 files changed, 1 insertions, 1 deletions

diff --git a/synapse/storage/user_directory.py b/synapse/storage/user_directory.py

index cab0afc5c3..bcf24fa4d0 100644
--- a/synapse/storage/user_directory.py
+++ b/synapse/storage/user_directory.py
@@ -368,7 +368,7 @@ class UserDirectoryStore(SQLBaseStore):
                 INNER JOIN users_in_pubic_room USING (user_id)
                 WHERE value MATCH ?
                 ORDER BY
-                    rank(matchinfo(user_directory)) DESC,
+                    rank(matchinfo(user_directory_search)) DESC,
                     display_name IS NULL,
                     avatar_url IS NULL
                 LIMIT ?