我试过[^A-Za-z0-9]帐篷[^A-Za-z0-9]。。具有?+*的多种组合
以及类似[^|[^A-Za-z0-9]]帐篷[^A-Za-z0-9]|$]的东西
我想匹配:
- 注意-否
- 看看帐篷-是的
- 帐篷很不错-是的
- 帐篷什么的-是的
- 露营、帐篷、户外-是(有些非字母数字分隔符)
如果它让它变得更容易,像"tenting"这样的东西也可以是匹配
我想我看的所有页面都遗漏了一些东西,但我真的被困在这里了。我需要在句子或分隔列表的开头、中间或结尾找到一个搜索词。我需要做多个陈述吗?
我希望有一种方法可以说使用这个表达式,但如果它是行的开始或行的结束
带有w
(非字母数字)
SQL> select str
2 from (select 'attention' str from dual union all
3 select 'look at the tent' str from dual union all
4 select 'tent''s are nice' str from dual union all
5 select 'something tent something' str from dual union all
6 select 'camping,tent,outdoors' str from dual)
7 where REGEXP_LIKE(str, '(W|^)tent(W|$)', 'i') ;
STR
------------------------
look at the tent
tent's are nice
something tent something
camping,tent,outdoors
SQL> select str,
2 case when REGEXP_LIKE(str, '(W|^)tent(W|$)', 'i') then 'YES' else 'NO' end matches
3 from (select 'attention' str from dual union all
4 select 'look at the tent' str from dual union all
5 select 'tent''s are nice' str from dual union all
6 select 'something tent something' str from dual union all
7 select 'tent' str from dual union all
8 select 'camping,tent,outdoors' str from dual);
STR MAT
------------------------ ---
attention NO
look at the tent YES
tent's are nice YES
something tent something YES
tent YES
camping,tent,outdoors YES