API for search with prefix?

yangbo_zhu - There are a lot of such params in V1 but did not find much in V2. Here is the one you could look at.

SELECT * FROM messages WHERE subject MATCHES = 'wireless' 
SELECT messages WHERE body MATCHES 'wireless' OR subject MATCHES 'wireless'

Thanks, VarunGrazitti! Does the "MATCHES" operator matches whole words or prefix?

yangbo_zhu,

here is the nice explanation, I'm using:

https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&v2.main=usingliql