Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 155 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

I'm trying to select all my own answers (stackoverflow) in data explorer.

I can't find any "help" page, and my sql-skills are limited...

Someone care to get me started?

(My goal is to select all my posts containing images (contains <img).)

share|improve this question
up vote 3 down vote accepted

Here's something to get you started:

SELECT Id, Score, Body, CreationDate 
FROM   Posts
WHERE  OwnerUserId = 276052  --your SO id
   AND PostTypeId=2  -- answers
   AND Body LIKE '%<img%'  --post body contains "<img"

Query on SEDE

share|improve this answer
    
Thanks! This is perfect! – aioobe Nov 7 '10 at 21:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .