Search(Select)

Search (Select)

To get all columns

Specify * after select.
Example) Get all columns for the record with id 10.

select * from Customer where id = 10;

Example) Get all columns of records with IDs between 2 and 5.

select * from Customer where  2 >= id and id <= 5;
select * from Customer where id between 2 and 5;

To get some columns

Specify the column name you want to retrieve after select.
Example) Get the name column for the record with id 10.

select `name` from Customer where id = 10;

Example) Get only the name column of records whose ID is between 2 and 5.

select `name` from Customer where  2 >= id and id <= 5;
select `name` from Customer where id between 2 and 5;