What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 134 Stack Exchange communities.

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

1 Answer 1

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 .