Find and replace data within a specified range in SQL.

[SpaceFish]

Hello friends, I don't know SQL. I have a lot of products on my website built with Wordpress and I want to make the same change to all of them. The change to be made is the same for all. I found the find and replace command online but I don't know how to apply it to a specific range. (For example, in 'Table1' table, in the 'B' column, change 'aaa' to 'bbb' for the data that has '5' written in it.) The replace command I found is: UPDATE table_name SET column_name = replace(column_name, 'searched_data', 'replaced_data'); Thank you for the help.