Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
836 views
in Technique[技术] by (71.8m points)

search - fulltext research don't match for preposition?

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...