Is there a MySQL Or Statement?

[scotchegg78]

Hey guys is there a Mysql or statement?

 

example  "SELECT * from leads WHERE HolderID = "'  . $userid . "' OR AgentID = "' . $userid "';

 

thanks in advance

[Barand]

Yes, that's fine.

 

Another version, replacing a string of OR statement like this

 

... WHERE (a=1) OR (a=2) OR (a=3)

 

is

 

... WHERE a IN (1,2,3)

 

 

So your query could be written as

 

SELECT * from leads WHERE '$userid' IN (HolderID, AgentID )