I wanted to update all the item_names and replace the number 21 with nothing for all items that had 21 at the end of the name and were in category A36PIPE


Update "inventory_items" set item_name = REPLACE(item_name,'21','');where item_name like '%21' and category_id = 'A36PIPE'