Blog

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
)

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 )