# MySQL Query - number of rows

**URL:** <https://www.ruby-forum.com/t/mysql-query-number-of-rows/135194>\
**Category:** Rails\
**Created:** [April 19, 2008, 1:08am UTC](https://www.ruby-forum.com/t/mysql-query-number-of-rows/135194 "2008-04-19T01:08:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sithadmin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sithadmin](https://www.ruby-forum.com/u/sithadmin)\
**Post date:** [April 19, 2008, 1:08am UTC](https://www.ruby-forum.com/t/mysql-query-number-of-rows/135194/1 "2008-04-19T01:08:07Z")

</div>

Hello,  
Stupid question, but how can I find out how many rows my SQL query  
returned?

@grab\_new\_entries = NewEntries.connection.select\_all(“SELECT displayname  
AS displayname FROM new\_entries”)

@grab\_new\_entries.num\_rows didn’t work…

Thanks,

- Jeff M.

---

<div class="post-metadata">

**Author:** ![sithadmin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sithadmin](https://www.ruby-forum.com/u/sithadmin)\
**Post date:** [April 19, 2008, 1:44am UTC](https://www.ruby-forum.com/t/mysql-query-number-of-rows/135194/2 "2008-04-19T01:44:21Z")

</div>

On 19 Apr 2008, at 00:08, Jeff M. wrote:

> Hello,  
> Stupid question, but how can I find out how many rows my SQL query  
> returned?
> 
> @grab\_new\_entries = NewEntries.connection.select\_all(“SELECT  
> displayname  
> AS displayname FROM new\_entries”)

It’s just an array. @grab\_new\_entries.length

Fred

---

<div class="post-metadata">

**Author:** ![sithadmin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sithadmin](https://www.ruby-forum.com/u/sithadmin)\
**Post date:** [April 19, 2008, 1:46am UTC](https://www.ruby-forum.com/t/mysql-query-number-of-rows/135194/3 "2008-04-19T01:46:12Z")

</div>

oh, I didn’t know that. Thanks!