mysql> select * from local_auth_account WHERE closed IS NULL AND LENGTH(name) != 6 limit 10;
+-----+-----------------+-------+--------+--------+--------+
| id  | account_type_id | name  | credit | params | closed |
+-----+-----------------+-------+--------+--------+--------+
| 100 |               3 | 12900 |   0.00 | 12900  | NULL   |
| 101 |               3 | 12901 |   0.00 | 12901  | NULL   |
| 102 |               3 | 12902 |   0.00 | 12902  | NULL   |
| 103 |               3 | 12903 |   0.00 | 12903  | NULL   |
| 104 |               3 | 12904 |   0.00 | 12904  | NULL   |
| 105 |               3 | 12905 |   0.00 | 12905  | NULL   |
| 106 |               3 | 12906 |   0.00 | 12906  | NULL   |
| 107 |               3 | 12907 |   0.00 | 12907  | NULL   |
| 108 |               3 | 12908 |   0.00 | 12908  | NULL   |
| 109 |               3 | 12909 |   0.00 | 12909  | NULL   |
+-----+-----------------+-------+--------+--------+--------+
10 rows in set (0.00 sec)

mysql> UPDATE local_auth_account SET closed = '2021-01-01 00:00:00' WHERE closed IS NULL AND LENGTH(name) != 6;
ERROR 1054 (42S22): Unknown column 'no_such_fields' in 'field list'