__PACKAGE__->set_sql(query_name_here => qq{
    UPDATE __TABLE__
    SET col3 = ?
    WHERE LOWER( col4 ) LIKE CONCAT('%', ?, '%')
};