Why does this work:

select * from person where firstname = 'William' or lastname like('W%')

but this produces an error:

select * from person where firstname like('W%') or lastname like('W%')

"Invalid keyword 'OR' command"

I have also tried:

select * from person where [firstname,lastname] like('W%')

Or, is there a different method of wildcard searching multiple fields?

-- 

--- 
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.

Reply via email to