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? Link to comment https://forums.phpfreaks.com/topic/22904-double-pipe-in-mysql/ 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 Link to comment https://forums.phpfreaks.com/topic/22904-double-pipe-in-mysql/#findComment-103283 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 ;) Link to comment https://forums.phpfreaks.com/topic/22904-double-pipe-in-mysql/#findComment-103285 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. Link to comment https://forums.phpfreaks.com/topic/22904-double-pipe-in-mysql/#findComment-103313 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). Link to comment https://forums.phpfreaks.com/topic/22904-double-pipe-in-mysql/#findComment-103379 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 ;) Link to comment https://forums.phpfreaks.com/topic/22904-double-pipe-in-mysql/#findComment-103486 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.