MySQL concat question
Posted
by Lucy Williard
on Stack Overflow
See other posts from Stack Overflow
or by Lucy Williard
Published on 2010-05-07T01:44:29Z
Indexed on
2010/05/07
1:48 UTC
Read the original article
Hit count: 284
Hi guys! I am somewhat mystified by concat and joins in MySQL 4. Here's where I am having an issue. I have two tables...
person
id, fname, lname, city, state, zip
capital
state, city
I am needing to generate all states and the number of persons (from the person table) from each. Something like ....
AK | 5
AL | 7
etc etc
Any advice would be appreciated. I so rarely am asked to do anything MySQL related and I'm stumped.
Lucy
© Stack Overflow or respective owner