嗯嗯,我没说清楚,我的查询条件是固定的,比如vedioSize < 1000,我想查不满足条件,不能写成vedioSize >= 1000.我只能在外围改。[/quote]
SELECT * FROM test.vedioinfo WHERE NOT IN(SELECT * FROM test.vedioinfo WHERE vedioName LIKE '%1%')
改成 SELECT * FROM test.vedioinfo a where not exist (select 1 from test.vedioinfo b WHERE a.id=b.id and b.vedioName LIKE '%1%') ;
SELECT * FROM test.vedioinfo WHERE NOT( vedioName LIKE '%1%' AND vedioSize > 1000)
改成 SELECT * FROM test.vedioinfo a WHERE not exists (select 1 from vedioName b where a.id=b.id and b.vedioName LIKE '%1%' and b.vedioSize < 1000);
SELECT * FROM test.vedioinfo WHERE NOT IN(SELECT * FROM test.vedioinfo WHERE vedioName LIKE '%1%')
改成 SELECT * FROM test.vedioinfo where vedioName not LIKE '%1%';
SELECT * FROM test.vedioinfo WHERE NOT( vedioName LIKE '%1%' AND vedioSize > 1000)
改成 SELECT * FROM test.vedioinfo WHERE vedioName not LIKE '%1%' and vedioSize < 1000;