select avg(score) as scoreave, sum(score) as scoresum, sum(size) as sizesum, count(ruler) as planet_tot from universe where alliance like '%bleh%'
How do I make the above query perform the same tasks but grab all the different alliances in the alliance field? I need to do the like rather than = as well because I want the results grouped by alliance but i need to be able to match partial not exact.
thanks for your time.
-Michael
How do I make the above query perform the same tasks but grab all the different alliances in the alliance field? I need to do the like rather than = as well because I want the results grouped by alliance but i need to be able to match partial not exact.
thanks for your time.
-Michael