Highlight() function in SphinxSE

General Discussions - English
1

Hello,
How to use Highlight() function in SphinxSE. I tried SphinxQL and Highlight function working.

2

In theory you can use arbitrary SQL expressions in the ‘select’ part (just like you do in SphinxQL)

SELECT * FROM myindex WHERE query='test;select=HIGHLIGHT() as highlight';

Beleive would need to create that as an attribute on the table.

CREATE TABLE myindex 
(
    id          INTEGER UNSIGNED NOT NULL,
    weight      INTEGER NOT NULL,
    query       VARCHAR(3072) NOT NULL,
    highlight   VARCHAR(4096)
    INDEX(query)
) ENGINE=SPHINX CONNECTION="sphinx://localhost:9312/test";

Remeber your fields need to be ‘stored’ on your underlying manticore index for HIGHLIGHT to work.

3

Thanks for the reply. It works