I've set up the crawl to index pages based on rendered output, but now in the SELECT statement for the query, what column name can I use in the where clause?
By using a keyword search, I get results in the hithighlightedsummary column even though the title and description for the page would not contain the searched for string. I've looked at all the other columns returned and none of them would work in the FullTextSqlQuery statement.
I'd like to use the FullTextSqlQuery instead of the Keyword search in order to provide wildcard searching by using the "like" clause.
I would love to be able to use the SELECT * syntax in order to see what is available, but this isn't possible. (I know why not.)