use SQL::Builder::Select; $select = new SQL::Builder::Select; $select->column('*'); $select->table('table'); $select->where_and('col1 = 1', 'col2 = 1'); print $select->return();