1
How can I update to change the value of 3 lines?
I have a similar structure:
Id | Nome | Ordinal
13 | Juizado Especial Cível | ª
14 | Juizado Especial Criminal | ª
15 | Juizado Especial Cível e Criminal | ª
I need to change the ordinal from 'ª' to 'º' of ids 13, 14 and 15 in a single query, instead of doing an update for each id.
How do I do?
Thank you very much.
UPDATE tabela SET campo = valor WHERE id IN (13,14,15)
– Don't Panic