Select * from NOT like '%partOfString%'

21 views
Skip to first unread message

Raymond Willems

unread,
Oct 19, 2017, 9:44:59 AM10/19/17
to OrientDB
Dear OrientDB-Community,

I want to query for all users that do NOT have a certain character in the name, e.g. search for all usernames that are not an email address:

Select * from OUser where name NOT like '%@%'


Using "NOT" doesn't work.

Any suggestions??

Best regards,
Raymond

Luigi Dell'Aquila

unread,
Oct 19, 2017, 9:49:13 AM10/19/17
to orient-...@googlegroups.com
Hi Raymond,

Try this:

Select * from OUser where not (name like '%a%')

Thanks

Luigi


--

---
You received this message because you are subscribed to the Google Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Message has been deleted

Raymond Willems

unread,
Oct 19, 2017, 12:00:14 PM10/19/17
to OrientDB
Thanks! This works fine! I propose to take this example into the documentation.

Best regards
Raymond

Luigi Dell'Aquila

unread,
Oct 20, 2017, 2:44:27 AM10/20/17
to orient-...@googlegroups.com
+1, I'll do it asap

--
Reply all
Reply to author
Forward
0 new messages