SQL Consistency ...

[scrappy@…]

I've been working on pg4wp in order to have it work with both WP 4.6 and PostgreSQL 9.5 ... running the regression tests, I've come across what appears to be the only occurance of the use of && instead of AND in the SQL code ...

I realize that this works under MySQL, but would appreciate it if it was possible to have it changed to SQL Standard AND ...

I have attached a patch against 4.6 ... the code is in wp-include/query.php

Thank you for your consideration ...

[scrappy@…]

Patch for query.php to replace && with AND for SQL

[dd32]

Hi @scrappy@… and welcome to Trac :)

I see no reason why we shouldn't be consistent here, I can't find any other occurrences of && in SQL in core, although I can see a few plugins which use the syntax.

I'd highly suggest adding a conversion for the standard MySQL logic syntaxes, just as plugins are going to do what plugins do :)

Introduced with [36138] in 4.5.

[dd32]

In 38491:

Query: Use AND in a SQL query rather than &&.
This appears to have been the only instance of && being used in SQL, so for consistency lets remove it.

Props scrappy@….
Fixes #37903.