The MAX_MATCHES tuning parameter

You can specify the maximum number of rows the search engine returns by using the MAX_MATCHES tuning parameter.

SELECT id, description FROM videos
    WHERE etx_contains(description,
    Row('multimedia document editor' , 
        'PATTERN_TRANS & PATTERN_SUBS & MAX_MATCHES=3'));

It is important to note that if you specify the MAX_MATCHES tuning parameter in a query, it is possible that not all rows that satisfy all the search criteria will be returned, since this is the nature of the tuning parameter. This can cause misleading results if a subsequent qualification, different from the etx_contains() operator, is applied in the query.