Extracting info from a string

[intervelopment]

Hey All,

I was wondering if someone could help me.

I have a wordpress install ... and it stores some info in the database as the following string

a:2:{i:0;s:1:"2";i:1;s:1:"4";}

This string varies in length based on how many images are in the gallery.

What i need to do is extract all the numbers that are enclosed in ""

So in the example above it would be 2 & 4.

Then after that i need to insert those numbers into a SQL statement like so:

SELECT * FROM gallery WHERE id = 'numbers go here'

Im hoping someone can help me out.

Cheers,

[Weedpacket]

Check out [man]unserialize[/man], but I would be surprised if Wordpress doesn't already provide a way to get at the information.