where子句

order by在where子句后面

字符串

用单引号把字符串包括在内

范围值检查between

1

select username from user where age between 18 and 23;

[18, 23]

空值检查

• is null
• is not null