Fetch the number of rows returned/affected by a SQL query

This is an old school answer but you could do it with something like:

SELECT * FROM foo WHERE ... UNION ALL select count(*), NULL from foo WHERE ...;

The last row will contain the count of the query