Everything MySQL

A great place to be!

Zachary Buckholz
  • Male
  • Mesa, AZ
  • United States
Share on Facebook Share on Facebook Share

Zachary Buckholz's Friends

  • Chris

Zachary Buckholz's Discussions

SQL query help
2 Replies

I am updating my Drinks Dictionary iPhone app which uses a sqlite database. I need to create a query to count how many items begin with the letter 'a', 'b', 'c', etc....I can get as far as 'select…Continue

Started this discussion. Last reply by Zachary Buckholz Sep 13, 2009.

 

Zachary Buckholz's Page

Gifts Received

Gift

Zachary Buckholz has not received any gifts yet

Give Zachary Buckholz a Gift

Latest Activity

Chris left a comment for Zachary Buckholz
"dude! 30 member in one month with a top ranked site on planetmysql.com.... I think this answers your original question!"
Sep 22, 2009
Zachary Buckholz replied to Zachary Buckholz's discussion SQL query help
"Thanks Sarah - you got me where I wanted to be. sqlite> select count(*), substr(name,1,1) from drinks group by…"
Sep 13, 2009
Sarah Sproehnle replied to Zachary Buckholz's discussion SQL query help
"Hi Zach, I believe what you want is something like: SELECT count(*), name FROM Drinks GROUP BY left(name,1); -Sarah"
Sep 13, 2009
Zachary Buckholz posted a discussion

SQL query help

I am updating my Drinks Dictionary iPhone app which uses a sqlite database. I need to create a query to count how many items begin with the letter 'a', 'b', 'c', etc....I can get as far as 'select DISTINCT substr(name,1,1) FROM drinks;How can I apply a GROUP BY clause or something else so in one query I can get every unique first character and a count of how many drinks start with that character?ThanksZachSee More
Sep 13, 2009
Zachary Buckholz is now a member of Everything MySQL
Sep 7, 2009

Comment Wall (1 comment)

You need to be a member of Everything MySQL to add comments!

Join Everything MySQL

At 9:09pm on September 22, 2009, Chris said…
dude! 30 member in one month with a top ranked site on planetmysql.com.... I think this answers your original question!
 
 
 

© 2017   Created by Chris.   Powered by

Badges  |  Report an Issue  |  Terms of Service