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 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 Administrator (CMDBA) > MySQL Certified Developer (CMDEV) > MySQL Certified Associate (CMA) > Comptia A+ Certified Professional IT Technician > > > > > > > > > > > > > > > > > > On Mon, 2009-03-02 at 13:04 -0800, Daevid Vincent wrote: > > > 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/refman/5.0/en/logical-operators.html > > > > > > ______________________________________________ > > This email has been scanned by Netintelligence > > http://www.netintelligence.com/email > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com