I'm interested in querying Data Explorer to see what percentage of our undeleted answers actually contain email addresses. I'm not experienced with T-SQL, though, so I'm not sure how I'd go about this in a regular T-SQL environment. Apparently I can't use a query like this:
select [OwnerUserId], [Post Link], Body from Posts where contains(Body, '@')
... because I get this error on running it:
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Posts' because it is not full-text indexed.
So what can I do to find posts containing an email address?