SQL Row-Value constructor in a Where-clause
-- tested with MySQL 5.6 SELECT id, name, status FROM history WHERE (name, status) = ('coffee', 1);
Result
| id | name | status |
|---|---|---|
| 1208 | coffee | 1 |
| 1217 | coffee | 1 |
| 1231 | coffee | 1 |
| 1234 | coffee | 1 |
| 1242 | coffee | 1 |
| 1247 | coffee | 1 |
| 1250 | coffee | 1 |
| 1257 | coffee | 1 |
| 1259 | coffee | 1 |
| 1260 | coffee | 1 |
| 1263 | coffee | 1 |
| 1266 | coffee | 1 |
| 1269 | coffee | 1 |
| 1275 | coffee | 1 |
| 1276 | coffee | 1 |
| 1280 | coffee | 1 |
| 1285 | coffee | 1 |
| 1287 | coffee | 1 |
| 1290 | coffee | 1 |
| 1293 | coffee | 1 |
| 1309 | coffee | 1 |
| 1314 | coffee | 1 |
| 1321 | coffee | 1 |
| 1322 | coffee | 1 |
| 1328 | coffee | 1 |
| 1329 | coffee | 1 |
| 1332 | coffee | 1 |
| 1334 | coffee | 1 |
| 1336 | coffee | 1 |
| 1338 | coffee | 1 |
| 1345 | coffee | 1 |
| 1352 | coffee | 1 |
| 1372 | coffee | 1 |
| 1375 | coffee | 1 |
| 1377 | coffee | 1 |
| 1380 | coffee | 1 |
| 1382 | coffee | 1 |
| 1406 | coffee | 1 |
More Snippets
Used Versions
PHP 8.2, Laminas MVC 3.2, Symfony 5.2, Laravel 8.28, PHPUnit 9.5, Doctrine ORM 2.8