I have a list of numbers like :
303102202
303102200
402123212
...
And Im trying to a grouped list. Normally I would say to MySQL
SELECT phone, count(*)
as num_amnt
FROM msglog
GROUP BY phone
ORDER BY num_amnt
And I would get the list grouped by phone. Now, how would I get it to group by area code?
Thanks a lot,
Alex