I'm trying to update a specific field and set it equal to value of a row in the same field.

What have I tried so far is this:

[![enter image description here](https://i.stack.imgur.com/wjrXW.jpg)](https://i.stack.imgur.com/wjrXW.jpg)

```
mysql> UPDATE tblitem SET imagefilename = (SELECT imagefilename from tblitem where itemid=2) where itemid=1'
1093 - You can't specify target table 'tblitem' for update in from clause

```

What I am trying to do here is to update the value of itemid 1 to the value of itemid 2.

Is that even possible? Thank you in advance.