PHP/MySQL: Basic SQL Commands ($$$): Basic Select Command

Basic SQL Commands ($$$)

You have answered 0 correctly out of 0 attempts.

Read page 312 to 317 about the Select command, sorting, limiting your results, and the use of the where clause of the command using both the comparison operators and the LIKE operator.

Notes:

A good reference for the select is the following tutorial link:

http://www.firstsql.com/tutor2.htm

The select statement is the most important statement to master. It allows you great flexibility at retrieving sets of data from the database with exactly the conditions, fields, and order that you want.

Question?

If you wanted to list all records from a table named employee with a last name ending in the letters ins which statement would you use?

SELECT * FROM employees WHERE last >= 'ins'

SELECT * FROM employees WHERE last('ins');

SELECT * FROM employees WHERE last LIKE '*ins';

SELECT * FROM employees WHERE last LIKE '%ins';