|
|
Posted by metaperl on 11/20/06 14:50
Does anyone see any noise words in this full-text searc query being
executing on MS SQL 2005?
SELECT t.Title, t.Organisation, t.ID, t.OnlineStatus
FROM Abstracts t
WHERE t.StatusID=3
AND CONTAINS ( t.ft, '( "acne") OR ("aeroallergen*") OR
("allerg*") OR ("antihistamine*") OR ("atopic") OR ("corticotherapy")
OR ("cyclosporin") OR ("derm*") OR ("dry skin") OR ("emollient*") OR
("eczema") OR ("histamin*") OR ("hives") OR ("immunoglobulin E") OR
("IgE") OR ("pruritis") OR ("psoriasis") OR ("rosacea") OR
("seborrhea") OR ("skin") OR ("stem cell*") OR ("stem mast cell*") OR
("utricaria") OR ("wart*" )' )
AND t.DateOnline BETWEEN '11/12/06' AND DATEADD(dd, 8,
'11/12/06')
Navigation:
[Reply to this message]
|