This repository has been archived by the owner on Jan 9, 2024. It is now read-only.
When using fulltext search + where() clause(s) in place even when I knew the combination should bring entries none was retrieved. I found that the $params array get populated in the wrong order. Eg; select *, MATCH(name,email,data) AGAINST(? IN NATURAL LANGUAGE MODE) AS relevance from `users` where guid = ? AND MATCH(name,email,data) AGAINST(? IN BOOLEAN MODE) array:2 [▼ "guid" => "9260a604-22b6-4075-891e-a82d52ba69fe" 0 => "text2search4" ] after ksort($params,SORT_NATURAL); the $params lists gets; array:2 [▼ 0 => "text2search4" "guid" => "9260a604-22b6-4075-891e-a82d52ba69fe" ]