What is differnce betwwen || & OR ?

bbsmfg3

I have some code written by a php programmer and they use "||" a lot instead of "OR" It seems on occasion the "||" doesn't work. Any idea why?

When should you use "||" instead of "or". It would be a lot of work to replace all of the "||" with "or" , but I will if need be.

nrg_alpha

bbsmfg3;10895141 wrote:
I have some code written by a php programmer and they use "||" a lot instead of "OR" It seems on occasion the "||" doesn't work. Any idea why?

This largely depends on the code.. without examples, its hard to say..but both 'or' as well as '||' works... I tend to stick with '||' personally.

bbsmfg3;10895141 wrote:
When should you use "||" instead of "or". It would be a lot of work to replace all of the "||" with "or" , but I will if need be.

Matter or preference I suppose? Both versions should work. Again, without code snippets of where one or the other doesn't work, it's hard to say for sure.

NogDog

"||" has a higher operator precedence than "or".

bbsmfg3

$res=$sql->query("SELECT * FROM webpay WHERE verify='WebPayOne' || verify='WebPayRec'");

Original code above. New code below

$res=$sql->query("SELECT * FROM webpay WHERE `verify`='WebPayOne' or `verify`='WebPayRec'");

bottom code seems to be working all of the time. Original code sometimes misses records

NogDog

In your examples, the "||" and "or" have nothing to do with PHP, but rather SQL. In MySQL the "||" and "or" operators have the same precedence, and therefore there should be no difference in the two queries. I cannot promise that is true for other DBMS's, though.

nrg_alpha

NogDog;10895145 wrote:
"||" has a higher operator precedence than "or".

Ho ho ho! I learn something new everyday! 🙂

laserlight

NogDog wrote:
In MySQL the "||" and "or" operators have the same precedence, and therefore there should be no difference in the two queries. I cannot promise that is true for other DBMS's, though.

In fact "||" is the concatenation operator in standard SQL. In that sense, "||" is as different from "or" in SQL as "||" is different from "." in PHP.