benjam Posted October 3, 2006 Share Posted October 3, 2006 I came across a query with a double pipe ( || ) in it and was wondering if the double pipe means anything in MySQL or if the designer meant ( OR ) and mistook it for PHP? Quote Link to comment Share on other sites More sharing options...
effigy Posted October 3, 2006 Share Posted October 3, 2006 http://dev.mysql.com/doc/refman/5.0/en/logical-operators.html Quote Link to comment Share on other sites More sharing options...
obsidian Posted October 3, 2006 Share Posted October 3, 2006 check out the [url=http://dev.mysql.com/doc/refman/5.0/en/logical-operators.html]logical operators page[/url] of the mysql manual. 'OR' and '||' are both accepted currently as logical [b]or[/b] operators.*doh - effigy's too quick ;) Quote Link to comment Share on other sites More sharing options...
benjam Posted October 3, 2006 Author Share Posted October 3, 2006 I thought it might be, but when I did a search for || it returned nothing.Thanks. Quote Link to comment Share on other sites More sharing options...
fenway Posted October 3, 2006 Share Posted October 3, 2006 Remember that they have the same precedence (unlike in Perl). Quote Link to comment Share on other sites More sharing options...
obsidian Posted October 4, 2006 Share Posted October 4, 2006 [quote author=fenway link=topic=110403.msg446316#msg446316 date=1159908795]Remember that they have the same precedence (unlike in Perl).[/quote]...or PHP ;) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.