Extracting records from a table with sorting?

Question

MySQL

How to display records not in order, but by rank value.
For example, there are 3 products, A has rank = 20, B = 10, and C = 40.
It needs to be displayed in ascending order in this case: B, A, B
Here is what is:

$sql = $mysqli->query("SELECT * FROM goods");

  foreach ($sql as $item) {
    echo $item["name"];
  }

Answer 1

SELECT * FROM goods ORDER BY rank ASC