MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
TableDelete::where
Set delete search condition
public mysql_xdevapi\TableDelete mysql_xdevapi\TableDelete::where(string where_expr);
Sets the search condition to filter.
where_expr
Define the search condition to filter documents or records.
TableDelete object.
Example 5.168 mysql_xdevapi\TableDelete::where
example
<?php $session = mysql_xdevapi\getSession("mysqlx://user:password@localhost"); $schema = $session->getSchema("addressbook"); $table = $schema->getTable("names"); $table->delete() ->where("id = :id") ->bind(['id' => 42]) ->limit(1) ->execute(); ?>