When writing a SELECT statement, you need to place the keywords in the correct order for the query to work right. For instance, you can't place the FROM keyword in front of the SELECT statement and get results:

FROM SELECT * lahmansbaseballdb.allstarfull; 

If you execute the previous query, you will get an error such as Error Code: 1064. 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 FROM SELECT * lahmansbaseballdb.allstarfull at line 1.