SQL copy row to another row in same table
<p>I need to copy all values from row1 to row2 where now all records contains "no tiltle"</p>

<p>I already tried:</p>

<pre><code>UPDATE `table` SET name=@tmp:=name,name=meta_title,meta_title=@tmp WHERE name='No Title';
UPDATE `bb_product_description` SET name = meta_title WHERE meta_title="No  Title"
</code></pre>

<p>but is just copy "No title to all"</p>

<p>Please help me</p>