可以使用 STRCMP('text', 'text2')

You can use STRCMP('text', 'text2')

update products 
set OrderNumber=OrderNumber+1 
where STRCMP(Name, 'bla') = 1;

我误解了你的意思.你能试试这样的吗?

I missunderstood your point. Can you try something like this?

SET @rownum:=0;
update 
set OrderNumber=@rownum:=@rownum + 1
from products
order by Name;