Search code examples
mysqlyii2sphinx

Yii2 Sphinx search greater than less or Less than less condition OR "BETWEEN"

$totalGeneralDownload = $squery->from('general_materials','general_materials_delta')
                                    ->match
                                    (
                                        (new MatchExpression())
                                        ->match([$param => $searchTitle])
                                        ->andfilterMatch(['and','download_count>=100','download_count<=100'])

                                    )
                                    ->showMeta(true)
                                    ->search();

This is my sphinx code, can anyone let me know how to use Between in Sphinx

Solution

  • I have R&D on it and find out that sphinx only text search not giving between type clauses so i think you should get id and then you have to filter by between clauses.