getting Images back to file

[Cujo]

I am sort of new to this and I have been searching for a few days now and can not find anything on this at all. What I need to be able to do is take a image stored in Mysql and save in back to the server as a file and I can not find out how. I know its got ot be simple and I am not the only one that needs to do this ... so can someone clue me in here.

Thanks

[arnyinc]

There is a different mysql forum. They should be able to help you better.

I believe there is select into ... outfile mysql statement. I've never used it though.

select picture_name from mytable where picture_id=190 into outfile 'out.jpg'