I have a simple table with (lets say three collumns)
id (primary key int) name (varchar) deleted (tinyint)
and what i'm trying to do it build a select like this
$Select = new Select('t', MyTable::find(), array( 'using' => array('id', 'name'), 'name' => 't', 'multiple' => 'multiple' ));
the only thing i would like to add is...
if the field deleted is 1, concat ' - deleted' with the column name in the select...
Any ideia how to perform it?