I have some 500 products where the v_products_model field needs to be changed. Currently all of this particular type of product is pre-fixed with "XOAR-XXXXXXX", I need to strip the "A" from each of these particular products setting the v_products_model field to "XOR-XXXXXXX".

I hope there is an sql command line that can be run on the database to do this, can anyone help please.

Thanks