What are the reserved words that cannot be used in the SQL query in Database Collection?

• The following are reserved words in SearchBlox, and cannot be used in the query directly.
  • indexdate
  • lastmodified
  • colname
  • url
  • source
  • col
• 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