billybrag Posted June 30, 2004 Posted June 30, 2004 is there an sql query that i can run that will update all of my models field to change it from a four digit numbe like it is now, ie 1234 to M1234 all of the fields will be preceeded by M thanks in advance :) "because it'll hurt more"- the greatest film of all time?
burt Posted June 30, 2004 Posted June 30, 2004 UPDATE products_description SET products_model = CONCAT('M', products_model) Should do it. Assuming you are wanting to change "products model" field of "products description" table.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.