mysql 查询 问题

[qqsweb]

$sql = 'SELECT * FROM `ecs_goods` WHERE `cat_id` = 1 LIMIT 0, 30 ';






这个查询cat_id等于1数据 现在我想cat_id等于2的也输出

也就是满足条件cat_id等于1或者等于2都是满足的

[dzxccsu]

$sql = 'SELECT * FROM `ecs_goods` WHERE `cat_id` = 1 or `cat_id` = 2 LIMIT 0, 30 ';

[CunningBoy]

$sql = 'SELECT * FROM `ecs_goods` WHERE `cat_id` = 1 or `cat_id` = 2 LIMIT 0, 30 ';