This is my code for a column TITLE (type fulltext):
if($this->Titolo && substr($this->Titolo, -1) === '*') {
$query->andWhere(['LIKE', 'Titolo', str_replace('*','%', '%'.$this->Titolo), false]);
} elseif($this->Titolo) {
$this->Titolo = trim($this->Titolo);
$titoloAgainst3 = "+".str_replace(' ', '+', $this->Titolo);
$query->andWhere(new yiidbExpression('MATCH(Titolo) AGAINST("'.$titoloAgainst3.'" IN BOOLEAN MODE)'));
}
The problem is that this code works if I search for "Catena beatissimum", while if I search for "Catena IN beatissumum" it returns no result. Why this problem?
Help me please, thank you!!!!
question from:
https://stackoverflow.com/questions/65882535/fulltext-research-dont-match-for-preposition 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…