mnoGoSearch 3.3.9 reference manual: Full-featured search engine software
Prev |  | Next

# UserCacheQuery

## Name

UserCacheQuery -- stores a search result to the database using a user-defined SQL query

`search.htm`

## Synopsis

UserCacheQuery {SQL}

## Description

UserCacheQuery specifies an SQL query to be run with every found document, typically to store search results to the database. This helps to use mnoGoSearch as an external fulltext search solution together with your database driven application.

All query string variables are available in the query using `${varname}` syntax. Additionally, individual `${url_id}`, `${score}`, `${rank}`, `${total}` variables are available for every document. `${score}` contains score value multiplied by `1000`, in integer format. `${rank}` contains the order of a document, starting with `0`. `${total}` contains the total number of documents found.

## Examples

    UserCacheQuery "INSERT INTO ${my_table_name} (url_id,score,rank) VALUES (${url_id},${score},${rank})"

## See also

HTDBAddr, HTDBDoc, HTDBList, ServerTable, the Section called Using mnoGoSearch as an external SQL full-text engine in Chapter 4.

Prev | Home | Next
URL | Up | URLDataThreshold