where('id=1 or id=2') # WHERE id=1 or id=2
where('id=:id1 or id=:id2', array(':id1'⇒1, ':id2'⇒2)) # WHERE id=:id1 or id=:id2
where(array('or', 'id=1', 'id=2')) # WHERE id=1 OR id=2
where(array('and', 'id=1', array('or', 'type=2', 'type=3'))) # WHERE id=1 AND (type=2 OR type=3)
where(array('in', 'id', array(1, 2)) # WHERE `id` IN (1, 2)
where(array('not in', 'id', array(1,2))) # WHERE `id` NOT IN (1, 2)
where(array('like', 'name', '%Qiang%')) # WHERE `name` LIKE '%Qiang%'
where(array('like', 'name', array('%Qiang', '%Xue'))) # WHERE `name` LIKE '%Qiang' AND `name` LIKE '%Xue'
where(array('or like', 'name', array('%Qiang', '%Xue'))) # WHERE `name` LIKE '%Qiang' OR `name` LIKE '%Xue'
where(array('not like', 'name', '%Qiang%')) # WHERE `name` NOT LIKE '%Qiang%'
where(array('or not like', 'name', array('%Qiang%', '%Xue%'))) # WHERE `name` NOT LIKE '%Qiang%' OR `name` NOT LIKE '%Xue%'