CGridView filter search


I need filter in varchar column with start filter LIKE ‘aaa%’ not default ‘%aaa%’. I found topic but it not work for me, I see empty table with ‘no results’ any suggestions? I use 1.1.8.


Post your code… how do you make the search?

irc channel solution that works perfectly

standard CRUD code


replaced with

$keyword = strtr($this->name, array('%' => '\%', '_' => '\_', '\\' => '\\\\'));



			$keyword . '%',

			false );

thank you SJFriedl :)