[Resolved] How can I do this with MySQL

Lets say I have a query like this: SELECT * FROM table WHERE something LIKE '%foo%'

And this is what I get back:

foo2
foo2
foo5
foo5

Now, I'd like to (with PHP) generate an output looking like this:

foo2 - 2
foo5 - 2

How can I do this?

SELECT DISTINCT field, count( field )
FROM table WHERE something LIKE '%foo%'
GROUP BY field

thanks for the reply coolT, but I don't know how to echo both values with PHP in one While loop...

SELECT DISTINCT field, count( field ) as num_count
FROM table WHERE something LIKE '%foo%'
GROUP BY field

then you would refer to
$get["field"];
$get["num_count"];
in the while loop

<table>
<?PHP
while ($get = mysql_fetch_array($result)){

echo "<tr><td>". $get["field"] . "</td><td>".$get["num_count"]."</td></tr>";

}
?>
</table>

worked like a charm, thx!