動かない書き方
$city = "Tokyo"; $query->andWhere("MATCH (users.city) AGAINST('+\":city1\" IN BOOLEAN MODE')") ->bind(':city1',$city);
このエラーが出る:
Invalid parameter number: number of bound variables does not match number of tokens
正しい書き方
$city = "Tokyo"; $query->andWhere("MATCH (users.city) AGAINST(:city1)") ->bind(':city1', "+\"{$city}\" IN BOOLEAN MODE");