How can I duplicate an existing record in a DB table
I have a table that has a large amount of columns and data, and once that data has been entered into a record, it will be useful to be able to duplicate that record as a great deal of the info is going to be similar if not exactly the same. The only things that will change from the original record to the duplicated will be details like dates and prices.
To save the administrators having to retype a majority of the same content, I want to be able to duplicate it to create a new version that can then edited as required, but I can't figure out how to do it.
Could you advise please?
I assume I need to do some sort of mysql select and insert code, but I don't know what, where how to implement it.
Thanks.