You can delete rows from a database table using the delete()
method. This method takes one argument, which is an SQL expression
that is used in a WHERE clause, as criteria for the rows to delete.
Example 276. Example of deleting rows from a Table
<?php
$table = new Bugs();
$where = $table->getAdapter()->quoteInto('bug_id = ?', 1235);
$table->delete($where);
Since the table delete() method proxies to the database adapter
delete()
method, the argument can also be an array of SQL expressions. The
expressions are combined as Boolean terms using an AND operator.
Note
The values and identifiers in the SQL expression are not quoted
for you. If you have values or identifiers that require quoting, you are responsible
for doing this. Use the quote(),
quoteInto(), and quoteIdentifier()
methods of the database adapter.