Does MySQL support something like an "OR" statement?

[Samishii23]

I came across something in my code today that made me wonder if theres a way to basicly incorporate two statements into one using something like a "OR" logic.

Basicly something like this:

SELECT * FROM `table` WHERE `user` = "someUser" OR WHERE `email` = "[e-mail]"

Don't bite my head off, i'm sure thats not proper MySQL syntax, just trying to get my point across.

Thanks in advance.

[NetDynamic]

Well other than your quotes being the wrong type that is exactly what the query looks like except the 2nd WHERE

Here its is::

SELECT * FROM table WHERE user = 'someUser' OR email = '[e-mail]'

[Samishii23]

Thanks. And my quotes work fine. Been using them for 2+ years, never had a problem.

[NetDynamic]

portability, but w/e

[Samishii23]

Portability? What doesn't use those quotes? Is it something in the MySQL config?

[NetDynamic]

I know some windows servers will error when using ", just saying.

[Samishii23]

Hmm. Thanks for the heads up!

[Turktaeteh]

Yes, you could use or in sql syntax. Just cut the second WHERE off and correct the quoting stuff. Like this..

select * from 'table' where user = 'someUser' or email = '[e-mail]'