mysql查询语句怎么写，有一个表

Question

mysql查询语句怎么写，有一个表，求实例就好了，拜/托了，linux操作系统的

Answer 1

单表查询
select * from tableName
条件查询 等值查询
select * from tableName where fieldName=""
条件查询 大于
select * from tableName where fieldName>100
条件查询 大于等于
select * from tableName where fieldName>=100
条件查询 In
select * from tableName where id in(1,2,3,4,5)
条件查询 not In
select * from tableName where id not in(1,2,3,4,5)
条件查询 like
select * from tableName where name like '张%'