SQL/select

//sampleテーブルのidとname
select id, name from sample;

//sampleテーブルのすべて
select * from sample;

//sampleテーブルのidが2のデータ
select * from sample where id = 2;

//sampleテーブルのcontentにbbbが含まれる
select * from sample where LIKE "%bbb%";
///sampleテーブルの末尾がbbb
select * from sample where LIKE "%bbb";
///sampleテーブルの先頭がbbb
select * from sample where LIKE "bbb%";
//sampleテーブルのcontentに変数が含まれる
select * from sample where LIKE "%{$str}%";

sampleテーブルのidが10以上20以下
select * from sample where id BETWEEN 10 AND 20;
select * from sample where id >=10 AND id <= 20;