Aibat's avatar
Level 2

FullText search and OrderBy

When I do a search and sort the result with latest() it outputs 2 results, but if I remove latest() it outputs 3 results, why?

select * from `applications` where exists (select * from `application_titles` where `applications`.`id` = `application_titles`.`application_id` and match (`title_ru`) against ('Buy' in natural language mode)) and `applications`.`deleted_at` is null order by `created_at` desc;
0 likes
0 replies

Please or to participate in this conversation.