Yes - it works in MySQL, as does ||. See:
http://dev.mysql.com/doc/refman/5.1/en/logical-operators.html#operator_and
On Mon, Mar 2, 2009 at 5:02 PM, John Daisley <
john.dais...@mypostoffice.co.uk> wrote:
> Never seen && used with MySQL, does it really work???
>
> As for other RDBMS, I reckon
Never seen && used with MySQL, does it really work???
As for other RDBMS, I reckon its likely to cause problems in Oracle as
&& is used for session substitution variables in SQL*Plus.
John Daisley
Email: john.dais...@butterflysystems.co.uk
Mobile: 07812 451238
MySQL Certified Database Administr
there is no && character matrix supported in the SQL92 spec located at
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
also there is no Truth Table for && but there IS a truth table for AND
conditionals.
Martin
__
Disclaimer and confident
