> Just Googling around it looks like "MATCH" is where the magic is.
>
> SELECT id, MATCH (title,body) AGAINST ('Tutorial') FROM articles;MATCH is used for full text indexing-- not quite the same thing, as my 'words' might not really be words, but rather just snippets of text, that if they're there, I want those records flagged(so I can delete them after a quick scan and confirm). This is used for the back-end of http://www.freetrialdownloads.com/. There are many submissions for people inserting their own affiliate ID's, etc., so I've created a 'bad' list of domain names and the like. I **could** make the change at the point of submission instead of the back-end management application, but changing the PAD poller would be more work vs. a good SQL statement... -- Derek _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
