[RESOLVED] Assistant Needed : specifing stored content in variable from copied rows

[camarosource]

I have a large amount of rows in a database that I want to copy. (I will need to do this a couple hundred times and then that would be it so it's not worth it for me to pay my custom php programmer to implement it into the program they are building). What I have been doing is using a query to copy all contents and then I manually change some of the parts afterwords. Here is the query I've been using in phpmyadmin for my duplicating of rows.

Example:

INSERT INTO camaro_models (variable1, variable2, variable3, variable4, variable5, variable6, variable7, variable8, m_order)


SELECT variable1, variable2, variable3, variable4, variable5, variable6, variable7, variable8, m_order FROM camaro_models WHERE mid = '10';

But would I would like to do is be able to run the query but instead of COPYING m_code I want to SPECIFY the content to store in the M_order variable all in the SQL query I execute in the phpmyadmin SQL ??

Thanks so much!

[Weedpacket]

Replace the "m_order" field in the select statement with an explanation of what you want instead.

[camarosource]

Weedpacket;10937609 wrote:

Replace the "m_order" field in the select statement with an explanation of what you want instead.

Not sure I understand

[johanafm]

Simply replace m_order with the value you want

SELECT variable1, ..., 'some value' FROM ...

[camarosource]

Excellent thank you very much.