How to get RowCount on MySQL?

and oracle knows this
just wait until they come to you asking for money

that said rewriting a query to get the count at the same time you get the actual results is one option
its not always possible since it may affect other aggregates with group by etc

so sometime running the query twice is the only opton

or just NOT writing your code / UI to show something that can be a pain or expensive to get