Query help with searching for users

[eluser]Aken[/eluser]
You'll likely need to write the query by hand for this. There's no good way for the query builder to section off conditionals in parentheses.

Remember, you don't need to use the query builder if your application isn't supporting multiple DB environments. Sure it's handy for creating simpler queries, but for complex you should stick with writing them by hand.