Hi Raymond, Try this:
Select * from OUser where not (name like '%a%') Thanks Luigi 2017-10-19 15:44 GMT+02:00 Raymond Willems <[email protected]>: > 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 > > -- > > --- > 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
