VistaDB 5
Unsupported syntax
Not Supported At This Time: This page is kept as a reference for what we intend to implement, but is not present in current engine.

  • Single word matches are to be separated by spaces.
    'any of these words'
    

  • Phrase matches should be enclosed in quotes.
    '"this exact phrase"'
    

  • Logical operations between two terms -
    Logical operations may also be included on search terms
    • AND - 'word AND another' - looks for a single documentid that has both words.
    • AND NOT - 'word AND NOT another' - looks for documentids that contains 'word' without the word 'another'.
    • OR - 'word or another' - looks for documentids that contain word or another and will return both.

Example

Full Text Search Examples
Copy Code
select * from TableName where Contains(columnname, 'pattern')




select * from mytable where contains (*, 'test AND phrase')




select * from mytable where contains (*, 'test AND NOT phrase')




select * from mytable where contains (*, 'test OR phrase')




select * from mytable where contains (*, '"test*"')


Match for test, testing, tested, etc.
See Also