SQL查询语句

Where查询子句练习
select * from order_info_table where product_id between 1002 and 1003;

select * from order_info_table where user_id in (1,3,5);

select * from order_info_table where order_status=‘pay’;

select * from order_info_table where user_name like ‘li%’;

select * from order_info_table where user_name like ‘_h%’;

select * from order_info_table where user_name not like ‘_h%’;

select * from order_info_table where user_name not like ‘%i’;

select * from order_info_table where price>8 and order_status=‘pay’;

select * from order_info_table where user_nick is null;

select * from order_info_table where user_nick is not null;