[wp-hackers] ordering by a custom field

[Brian Fidler]

I'm setting up a custom query for a second loop that displays on my page. I
want to set a custom field titled 'artwork_order' and be able to access that
field using ORDER BY in my query.

something like this, however this isn't working.

ORDER BY wp_postmeta.meta_value['artwork_order'] ASC

Is there a proper way to do this?

thanks
brian