How does the timing of column creation in a PHP query impact the usage of that column in WHERE versus ORDER BY clauses?

When creating a column in a PHP query, the timing of its creation can impact its usage in WHERE versus ORDER BY clauses. If you want to use the column in the WHERE clause, it should be created before the WHERE clause in the query. If you want to use the column in the ORDER BY clause, it should be created before the ORDER BY clause in the query.

// Creating a column before using it in WHERE and ORDER BY clauses
$query = "SELECT *, column_name AS new_column FROM table_name WHERE condition = 'value' ORDER BY new_column";