ok, now i know this isn’t a purely rails problem but if you could help
me out that’d be great.
coming from a SQL Server background switching over to mysql hasn’t been
that much fuss but i’m getting problems with computed fields.
in my head this should work,
select team_name, COUNT(team_id) as member_count
where member_count = 2
group by team_name
now here this should basically group the members together and calculate
the members within each team, then only show the teams who have 2
however when i run this it tells me,
undefined field ‘member_count’
…can i not do a where clause on a computed field?, if so how can i get
appreciate any pointers you can give me?