Searching is a core feature of Manticore Search. You can:

• Perform full-text search and implement search result highlighting
• Perform k-nearest neighbor search
• Apply non-full-text filtering
• Use expressions for filtering
• Utilize various search options
• Employ multi-queries and sub-selects
• Conduct aggregations and faceting of search results
• And much more

SQL:

SELECT
    select_expr [, select_expr] ...
    [FROM tbl_name
        [{INNER | LEFT} JOIN tbl2_name]
        [WHERE where_condition]
        [GROUP BY {col_name | expr}, ... ]
        [HAVING where_condition]
        [ORDER BY {col_name | expr}
            [ASC | DESC], ... ]
    ]
    [LIMIT {[offset,] row_count | row_count OFFSET offset}]
    [OPTION option1[, option2] ...]

JSON:

POST /search
{   
    "index" : "index_name",
    "options":   
    {
      ...
    }
}