I need to update a particular column value from Yes to NO after particular time interval mentioned in the same table.

Table Structure 

```
`v_id` int(11) NOT NULL,
`society_id` int(11) NOT NULL,
`voting_for` varchar(500) COLLATE utf8_bin NOT NULL,
`active` enum('Yes','No') COLLATE utf8_bin NOT NULL DEFAULT 'Yes',
`voters` varchar(10000) COLLATE utf8_bin DEFAULT NULL,
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`created_by` int(11) NOT NULL
`active_till` date NOT NULL

```

How can i change Active column value from Yes to No once active\_till period expires. i'm doing this in Codeigniter.