update the media.itemtype

Hi,

We have pdf documents in the media table. The itemtype is 'media' but should be of type 'MyMedia'. We use this special type as a marker.

An sql update statement would look like this:

 update media set itemtype = 'MyMedia'
 where itemtype = 'Media'
 and mime = 'appication/pdf'

• Can we do this with impex directly?

• Can we do this with an sql update statement on the running system?