How to get total count of this query without calling another one?
<p>I have a query that I need to get a total count of before I paginate. I was wondering if there was a way to return the total count within the same query before the limit is executed. I have to pass the total value to my back-end if thats possible.</p>

<p>What the query does-<br>
-Finds rows that have are within a specified radius,<br>
-that match a user entered keyword,<br>
-orders by date then limit,<br>
-offset for pagination.  </p>

<pre><code>SELECT *,   
( 3959 * acos (cos ( radians(?) )* cos( radians( lat ) )*cos( radians( lng ) - radians(?) )+ sin ( radians(?) )* sin( radians( lat ) ))) AS distance   
  FROM job_posting  
 where job_title like ?  
 HAVING distance &lt; ?   
ORDER BY date_created DESC   
limit ?, 25  
</code></pre>

<p>I've looked at a couple different examples, but not sure how to implement it on this query. Any advice helps. </p>