Select * from NOT like '%partOfString%'

[Raymond Willems]

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]

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.

[Raymond Willems]

Thanks! This works fine! I propose to take this example into the documentation.

Best regards
Raymond

[Luigi Dell'Aquila]

+1, I'll do it asap

--