OR statement

[passingTime]

Hello,

 

Is there anyway to filter a recordset using an OR statement?

 

for example:

"SELECT * FROM DB1 WHERE example = %s"

 

can i make it so it filters by 2? So something like:

 

"SELECT * FROM DB1 WHERE example = %s or example2 = %s"

[Maq]

Have you tried it?  From you syntax, it looks like you should be using LIKE, not =.

[passingTime]

It works without the OR statement but i'm not sure how to use OR statements like this.

 

So is that how you usually do it?

[Maq]

This is the correct logic but I'm telling you that the syntax is invalid.  It should not work with or without the or like this.

SELECT * FROM DB1 WHERE example = %s or example2 = %s

[Muddy_Funster]

Could you post your ACTUAL query (copy & paste) - it makes solving these things much easier

[passingTime]

Not something you solve i'm just asking if you can use OR statements and if so how.

 

 

[Maq]

i'm just asking if you can use OR statement

Yes.

 

and if so how

Example:

SELECT * FROM DB1 WHERE example LIKE '%s' OR example2 LIKE '%s';

[passingTime]

Ok thanks i think i'll look into PHP and SQL a little more...

[passingTime]

Oh wait i made a mistake somewhere else but yeh that does actually work lol.

[Maq]

Oh wait i made a mistake somewhere else but yeh that does actually work lol.

Not sure what you're talking about.  If you still need help post the query and error message.

[fenway]

And again, post the solution.