Add Condition To Controller Query

I am very sorry for that kind of easy question but i cannot find any matching issue to my simple question.

I am using the following code in my controller and i would like to add a condition like my keyword to search

within the column called ‘url’ … i need a generated query like

select * from redirects where url =’%test%’;

Thanks for your replies.

$keyword = 'test';  


$criteria=new CDbCriteria();

$criteria->order = 'url asc';


$pages=new CPagination($count);

// results per page




$this->render('listing', array('redirects' => $models,'pages' => $pages ));

$criteria->addSearchCondition('url', $keyword);