How do I duplicate a row?

[multimediocrity]

I would like to duplicate a row and change one of the cells.
Is there a way to do it using a MySQL query? I know I can do it using a Select and Insert, but I wanted to know if there was a way to do it with one.

Thanks.

[NogDog]

Assuming PHP as the application code, $id is the primary key (auto-incremented INT) of the row you want to duplicate and $newValue the different value for the "foo" column:

$sql = sprintf(
    "INSERT INTO some_table (foo, bar) (SELECT '%s', bar FROM some_table WHERE id = %d)",
    mysql_real_escape_string($newValue),
    (int) $id
);