Example Full Text SQL Queries

A basic query
select Title, Author, Description, rank from scope() where freetext(DEFAULTPROPERTIES, 'keyword') order by rank

How to specify a search scope
select Title, Author, Description, rank from scope() where "scope"='my scope name' and freetext(DEFAULTPROPERTIES, 'keyword') order by rank

Last edited Nov 1, 2007 at 4:06 PM by kindohm, version 1

Comments

No comments yet.