MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
TableDelete::orderby
Set delete sort criteria
public mysql_xdevapi\TableDelete mysql_xdevapi\TableDelete::orderby(string orderby_expr);
Set the order options for a result set.
orderby_expr
The sort definition.
A TableDelete object.
Example 5.167 mysql_xdevapi\TableDelete::orderBy
example
<?php $session = mysql_xdevapi\getSession("mysqlx://user:password@localhost"); $schema = $session->getSchema("addressbook"); $table = $schema->getTable("names"); $table->delete() ->where("age = :age") ->bind(['age' => 42]) ->orderby("name DESC") ->limit(1) ->execute(); ?>