updating specific rows

[thalegend77]

Hello all,

When I was creating a database I misassigned some rows and now I just want to change those 4 rows but can't figure out how to do it. I tried using this command

 update variables set bl_id=16 where bl_id in (SELECT bl_id from variables where var_id between 379 and 382)

Any help would be greatly appreciated. Thanks. I'm am using Mysql.

[thalegend77]

Ummm nevermind I figured it out. I feel so dumb, all I had to use was and.