Add Searchcondition Limiting The Result

Hi experts,

I need to LIMIT the results by using LIMIT

im using like this… but i need to LIMIT the results as it is fetching all the results from database…


     	$names = Model::model()->findAll( $q );

I need my query like this…

SELECT * FROM  `table` WHERE name REGEXP  'states' LIMIT 0 , 10

can anyone pls help me to write LIMIT with addSearchCondition

Many Thanks,

see the below link

try with limit and offset properties like



before calling findtAll

If work let me know :)

thanks for your reply. Its working…thanks alot

its working only with 


and with