I would like to run a delete sql query with multiple values in it. But I am unable to do so. So need your help on this.

In controller.php page:

```
function deleteFiles()
{
$mainframe = &JFactory::getApplication();
if ($this->_model->deleteFiles()) {
$mainframe->enqueueMessage('Files deleted successfully');
} else {
$mainframe->enqueueMessage('Files not deleted');
}
    ARequest::redirectList($this->_controllerName);
}

```

In model.php page:

```
function deleteFiles($field, $value)
{
$query = 'DELETE FROM ' . $this->rquote($this->_table->getTableName()) . ' WHERE ' . $this->rquote($field) . ' = ' . $this->_db->Quote($value);
$this->_db->setQuery($query);
return $this->_db->query();
}

```

In file.php page

```
function deleteFiles()
{
$this->_db->setQuery('DELETE r 
            FROM #__booking_reservation AS r 
            WHERE r.state = ' . FILES_ACCEPT);
$this->_db->query();
return true;
}

```

Now in file.php page, I want to add FILES\_BOOKED, FILES\_CANCEL, FILES\_DELETE along with the present FILES\_ACCEPT. But I don't know how to do it.

Can you help me out.