MYSQL modify column fields based on another column fields

Question

Assuming I have such table

|---------------------|------------------|
|          ID         |       Name       |
|---------------------|------------------|
|          1          |         x        |
|---------------------|------------------|
|          ..         |         x        |
|---------------------|------------------|
|          N          |         x        |
|---------------------|------------------|

I need to change name fields to "z" for IDs between 30 and 100. Is there any way to use a loop or a while condition instead of doing this:

UPDATE table
SET Name = 'z'
WHERE ID = 30
OR ID = 31
OR ID = 32
...

RiggsFolly · Accepted Answer · 2020-01-14 13:05:03Z

3

Simply specify that in the where clause

WHERE ID >= 30 AND ID <= 100

answered Jan 14, 2020 at 13:05

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tim Biegeleisen · Accepted Answer · 2020-01-14 13:05:44Z

3

You could use BETWEEN here:

UPDATE yourTable
SET Name = 'z'
WHERE ID BETWEEN 30 AND 100;

answered Jan 14, 2020 at 13:05

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Collectives™ on Stack Overflow

MYSQL modify column fields based on another column fields

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related