SQL Selectable Items

• VERSON()
• CURRENT_DATE
• USER()
• SHOW DATABASES; - Show the databases that exist on the server.
• SHOW TABLES;
• USE dbname - Use a specific database.
• LOAD DATA;
• DESCRIBE - Get information about a table's columns.

Keywords

• DISTINCT
• ORDER BY - Set the order the output is displayed in.
• COUNT - Count rows in a table.

Comparison Operators

• IS NULL
• IS NOT NULL
• LIKE m% - Items beginning with the letter m.
• NOT LIKE
• REGEXP