SQL语句的IN操作符
SELECT "count"(*) FROM at_account WHERE channel in ('tian01','tian02','tian03');
不如
SELECT "count"(*) FROM at_account WHERE channel LIKE 'tian%';
SQL语句的IN操作符
SELECT "count"(*) FROM at_account WHERE channel in ('tian01','tian02','tian03');
不如
SELECT "count"(*) FROM at_account WHERE channel LIKE 'tian%';
转载于:https://my.oschina.net/u/1433006/blog/1616197