求助，sql优化

SELECT COUNT(amoid) num FROM alp_merchant_order WHERE (mobile LIKE '%15011236833%' || phone LIKE '%15011236833%') AND orderstatus NOT IN (0,17) AND createtime >='2016-05-26 15:01:02';

看下这个sql，全表扫描 ，帮忙优化下

非常感谢