MySQL Select all columns with one alias column

Select all columns with one alias column in MySQL:

select FirstName as FN, * From `User`

If you try to run the above query you will get the following error:

You have an error in your SQL syntax; check the manual that corresponds 
to your MySQL server version for the right syntax to use near

The solution is to add an alias to * in the above query:

select FirstName as FN, User.* From `User`

In the above query, we added the table name as an alias to * to fix the issue.