instr

最新推荐文章于 2025-06-14 12:43:06 发布

转载最新推荐文章于 2025-06-14 12:43:06 发布 · 149 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/wangchuanfu/p/10255176.html

文章标签：

#数据库

MySQL： select * from tableName where name like '%helloworld%';
Oracle：select * from tableName where instr(name,'helloworld')>0;

select BLACK_VALUE, COUNT(*)as total
         from EC_COUPONS_BLACK
         where IS_DELETE='N'

 AND   BLACK_TYPE='goods'
           and IS_ALL_COUPONS='Y'
       and   instr(','||BLACK_VALUE||',',','||(select goods_id from goods where goods_no = '133163'and is_delete = 'N')||',') >0
 GROUP BY BLACK_VALUE