I need to update a column using the update statement.
SELECT *
FROM tng_managedobject
WHERE severity <> 0
AND class_name like 'Plaza_VES_Junction_Box'
AND propagate_status <> 0
I need to update the propagate_status for all these classes to 0. How can I use the SQL update statement to do this?
A simple update statement like this will do it:
update tng_managedobject
set propagate_status = 0
where severity <> 0
and class_name = 'Plaza_VES_Junction_Box'
and propagate_status <> 0
You don't need a LIKE clause when you are specifying the exact class name. = will suffice.
update tng_managedobject
set propagate_status = 0
where severity <> 0
and class_name like '%Plaza_VES_Junction_Box%'
and propagate_status <> 0
For the class_name column, If you know the exact name, it is better to use =. If you are looking for a string that contains Plaza_VES_Junction_Box anywhere use %
UPDATE table1
SET table1.propagate_status = 0
FROM tng_managedobject AS table1
WHERE table1.severity <> 0
AND table1.class_name like '%Plaza_VES_Junction_Box%'
AND table1.propagate_status <> 0
like to include wildcards.UPDATE tng_managedobject
SET propagate_status = 0
WHERE severity <> 0 AND class_name like('Plaza_VES_Junction_Box')
As @zedfoxus points out, you don't need a like statement. To maintain difference in answers, use his since it is more efficient than mine.
update tng_managedobject set propagate_status=0
where severity <> 0 and class_name like 'Plaza_VES_Junction_Box'
and propagate_status <> 0
update tng_managedobject
set propagate_status = 0
where severity <> 0
and class_name = 'Plaza_VES_Junction_Box'
and propagate_status <> 0
update tng_managedobject
set propagate_status = 0
where severity <> 0
and class_name like 'Plaza_VES_Junction_Box'
and propagate_status <> 0
