quick question about characters db

[BloodLord]

Hi all.

here is my question

In the characters DB there is a table called item_instance and one of the fields (the "data") is a logtext filed.

For one of the characters it looks like this:

514 1073741824 3 2650 1065353216 0 19 0 19 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 25 0 0 

Is there a quick way to extract the 4th element from this log? or maybe more just in case needed, but the 4th one is the most important cuz it's the item's ID.

I want to save all the owner_guid and itemID values in a different DB.

pls help.

Thanks

[VladimirMangos]

Something like (maybe wrong in exactly indexes)

SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 4 + 1), ' ', -1)