Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 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 ran this query on Data Explorer. But it could include users who are author of some mobile apps. How to get user with High reputation and has written atleast one book?

share|improve this question

closed as too localized by Sathya, ben is uǝq backwards, kiamlaluno, hims056, BinaryMisfit Mar 4 '13 at 11:23

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Which query are you running? Please give full details. What's your actual question? – hims056 Mar 4 '13 at 10:16
before I hit 'save edits', I'm already 2 votes down :( – Typist Mar 4 '13 at 10:17
@hims056 - Jon Skeet altered the query in realtime to remove his trace from it... he's a humble man you know! :D – bPratik Mar 4 '13 at 10:18
@bPratik, chuck norris = Jon Skeet :D – Typist Mar 4 '13 at 10:19
This is really a "why doesn't my SQL work" question, the answer being that Jon Skeet doesn't have the words "author" and "book" both in lower case in his About Me section. – ben is uǝq backwards Mar 4 '13 at 10:19
The downvotes are likely because you seem to make the assumption that Jon Skeet isn't that much of a reputable author because he's not showing up in your (broken) SQL query. Which, you have to admit, is a bit ridiculous :) – Pëkka Mar 4 '13 at 10:22
It could include people whose bio includes the words "some day I hope to author a book" or "my favourite author is ... who has written a great book". There is no hope for your query. – Kate Gregory Jul 4 '13 at 15:48

Your query goes

select displayname, reputation, AboutMe, websiteurl, location, age from users 
where  AboutMe like '%author%book%' order by reputation desc;

Jon's profile does contain the word "Author", but not the word "book", so he's not caught by your query. Not sure why you're expecting to see him there?

Edit: also, the query is case sensitive, so you'd have to specify %Author%

share|improve this answer
Still wouldn't work. Author is capitalised. – ben is uǝq backwards Mar 4 '13 at 10:20
@ben oh, LIKE is not case insensitive in MS SQL (or whatever the data explorer is running)? Ok. It is in mySQL, so I thought it was part of the standard – Pëkka Mar 4 '13 at 10:20
@ben, I assume db collation is case insensitive – Typist Mar 4 '13 at 10:20
That's a pretty large assumption @Typist... to be safe you should prove it before assuming anything to do with databases. – ben is uǝq backwards Mar 4 '13 at 10:21
Indeed, it's case sensitive. – Pëkka Mar 4 '13 at 10:23
Yup Pekka, I decided to prove it as a case-insensitive collation seemed a little strange for a company like SE, cc @Typist – ben is uǝq backwards Mar 4 '13 at 10:25
How come the reputation column shows 528,878 when its supposed to be 539,513? – AbZy Mar 4 '13 at 10:40
@AbZy the data in the data explorer is not live – Pëkka Mar 4 '13 at 10:40
I see, that makes sense. – AbZy Mar 4 '13 at 10:41

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