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
contained within this transmission.
> Subject: && vs AND
> From: dae...@daevid.com
> To: mysql@lists.mysql.com
> Date: Mon, 2 Mar 2009 13:04:32 -0800
>
> Someone sent me a huge SQL query today that used "&&" instead of "AND"
> all over th
Someone sent me a huge SQL query today that used "&&" instead of "AND"
all over the place. I was a bit surprised that it is legal mySQL, but I
was always under the impression that is not proper. Can anyone confirm
or deny this? Like will ALL SQL RDBMS support that syntax?
http://dev.mysql.com/doc/
