Count Records Returned MySQL Doctrine

Question

Hi,

How do I check the number of records returned from a search of my MySQL database with a statement like this:

$searchKey = 'Something to search for'; 
$searchResults = Doctrine::getTable('TableName')->createQuery('t')- 
    >where('columnName LIKE ?','%'.$searchKey.'%')->execute(); 

Answer 1

maybe

$searchResults->rowCount();

from here