- The following are reserved words in SearchBlox, and cannot be used in the query directly.
- It is required to map and rename the field with the reserved word.
- The following query shows how to use a reserved word in a query
select id as uid,name as title, source as "mysource", indexdate as "mydate",
url as "myurl"
To learn more on SQL query syntax for Database collection read: SQL Query for Database Collection