Bulk change to MYSQL

Question

Hey, guys, all right?

I have a database in mysql and I need to make a massive change, it’s like?

I want to change all records from the "show_address" column of the ptv_osrs_properties table to "1".

I have about 300 records, I can do this in bulk at once?

Thank you!

Answer 1

My suggestion update without Where

UPDATE ptv_osrs_properties 
SET show_address = '1'

Answer 2

I’m not sure I got it right, but if you want to update all the table records, just do an update:

update ptv_osrs_properties set show_address = '1';