"IN"可以吗?运营商在Oracle中使用LIKE通配符(％)? [英] Can the "IN" operator use LIKE-wildcards (%) in Oracle?

问题描述

我已经搜索了这个问题，并在MySQL中找到了答案，但这是该语句无法跨入Oracle的事件之一.

I have searched this question, and found an answer in MySQL but this is one of those incidents where the statement fails to cross over into Oracle.

我可以在"IN"中使用通配符吗? MySQL语句?
几乎总结了我的问题以及我想做什么，但是在Oracle中

Can I use wildcards in "IN" MySQL statement?
pretty much sums up my question and what I would like to do, but in Oracle

我想找到合法的

Select * from myTable m
where m.status not in ('Done%', 'Finished except%', 'In Progress%')

感谢您的帮助

推荐答案

Select * from myTable m
where m.status not like 'Done%' 
and m.status not like 'Finished except%'
and m.status not like 'In Progress%'

这篇关于"IN"可以吗?运营商在Oracle中使用LIKE通配符(％)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！