I noticed that Kirby’s database class can’t reference the same bind parameter multiple times in a single query.
$query ->where('match (name) against (:name_param) > 0') ->order('match (name) against (:name_param) desc');
Doing this returns an empty collection. No errors, just an empty collection - even though the query returned by
->debug() executes correctly when copy/pasted into a SQL client.
I don’t know much about PDO - is this expected behavior?