I use SphinxSE instead of
FULLTEXT
. Sphinx settings are for end-users of a search engine. According to the official documentation ,
> LIMIT clause. Both LIMIT N and LIMIT M,N forms are supported. Unlike
> in regular SQL (but like in Sphinx API), an implicit LIMIT 0,20 is
> present by default.
Therefore, any query returns only 20 rows
MariaDB [sphinx]> SELECT * FROM t1 WHERE query='test;mode=any';
+------+--------+---------------+
| id | weight | query |
+------+--------+---------------+
| 556 | 1 | test;mode=any |
| 864 | 1 | test;mode=any |
| 1329 | 1 | test;mode=any |
| 1781 | 1 | test;mode=any |
| 1832 | 1 | test;mode=any |
| 2157 | 1 | test;mode=any |
| 2388 | 1 | test;mode=any |
| 2889 | 1 | test;mode=any |
| 3118 | 1 | test;mode=any |
| 3155 | 1 | test;mode=any |
| 3255 | 1 | test;mode=any |
| 3485 | 1 | test;mode=any |
| 3495 | 1 | test;mode=any |
| 3623 | 1 | test;mode=any |
| 4034 | 1 | test;mode=any |
| 4525 | 1 | test;mode=any |
| 4563 | 1 | test;mode=any |
| 4659 | 1 | test;mode=any |
| 4736 | 1 | test;mode=any |
| 4807 | 1 | test;mode=any |
+------+--------+---------------+
20 rows in set (0.027 sec)
I experimented with various settings in the sphinx.conf
, but am unable to change the setting to return more results in a SQL query.
Asked by Googlebot
(4551 rep)
Apr 13, 2021, 11:46 AM
Last activity: Apr 15, 2021, 09:49 PM
Last activity: Apr 15, 2021, 09:49 PM