Is there an alternative for SQL's SELECT DISTINCT?

I’m using Manticore for autocompletion and I need only unique results.
But it returns all matching results which often repeat.

Simple SELECT DISTINCT name FROM my_table doesn’t work.
Is there any way to fetch only unique results? I searched through all the docs and forum and couldn’t find any solution.

А какой тип у name?

Тип text, мы ведь делаем full-text search по этому полю.

Может https://manual.manticoresearch.com/Functions/Searching_and_ranking_functions#REMOVE_REPEATS() поможет?

@Sergey да похоже то что надо! Спасибо.

There is also GROUP BY

 SELECT name FROM myindex GROUP BY name