What causes 'you have an error in your sql syntax' in sql?

Example:

SELECT FROM users WHERE name = 'John';

There's a syntax error in the SQL query you've written.

Solution:

Review the SQL query for any missing or misplaced keywords. In this instance, the error is due to missing column names after SELECT.

SELECT name FROM users WHERE name = 'John';