Tabelle vom MySQL abfragen und aktualisieren

UPDATE tabelle SET abc = 'neu' WHERE id IN (
   SELECT id FROM (
      SELECT * FROM tabelle WHERE def IS NULL
      AND def NOT LIKE 'das nicht%'
      ORDER BY def
   ) AS t
)