I am trying to set up a query which will select rows from a mysql db based on certain criteria. Once the rows are selected I need to then duplicate the row but with one value changed in the last column.
Can anyone tell me how I would go about doing this?
I can set up the select statement to choose the rows I need to based on certain criteria but I don’;t know how to do the duplication part. Any help would be much appreciated.