chris48s / cakephp-searchable Goto Github PK

By default, SQL's Full-Text Search seems to handle some special characters within the AGAINST string as code, even though they're within quotes and bound.

For example:

$query = $myTable
    ->find('matches', [
        [
            'match' => 'textcol1',
            'against' => '*'
        ]
    ]);

will cause

Error: SQLSTATE[42000]: Syntax error or access violation: 1064 syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'

This behaviour has been observed in closely described here: https://stackoverflow.com/questions/25088183/mysql-fulltext-search-with-symbol-produces-error-syntax-error-unexpected/25972465#25972465

Hey,

Great plugin! Is there any way you can add the relevancy score to the list of columns/fields that are retrieved...

I am searching multiple tables, combining the results, and it would be awesome if I could sort all the results by the relevancy...

Thank you!

Jeffrey