order by in codeigniter 4 code example

Example 1: codeigniter query builder order by

$this->db->order_by('title', 'DESC');
// Produces: ORDER BY `title` DESC

Example 2: codeigniter 4 query builder select

$builder->select('title, content, date');
$query = $builder->get();

// Executes: SELECT title, content, date FROM mytable