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 am using the following incredibly useful utility...

http://data.stackexchange.com

The following shows the posts started / answered by me.

select * from Posts where OwnerUserId = 139150  

How do I restrict the search only to the questions asked by me? I do not want to find the posts where I have written an answer.

share|improve this question
2  
Just in case you didn't know, you can also see your own questions in your profile – Brad Mace Jun 24 '11 at 5:30
up vote 4 down vote accepted

You need to filter based on the PostTypeId. 1 is for questions.

select * from Posts where OwnerUserId = 139150 and PostTypeId = 1

share|improve this answer
    
Thanks. But this does not show the title. I do not want to select the "Body" column. How to get the title in the query. – shantanuo Jun 24 '11 at 5:43
1  
@shantanuo This does show the title, but you need to scroll far to the right to find it. If you want just the title, change select * to select title. Also, there is a typo. OwnerUsedId needs to be changed to OwnerUserId. – ughoavgfhw Jun 24 '11 at 6:27

You must log in to answer this question.

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