I think you want order by entity1. if your entity1 data type is integer then no need to change it into integer or if it is not then you should do it. below is query for you.try this one.

select entity1,cast(entity1 as integer) as order_id from Table_Name order by 1 asc;


CASTING attributes for Ordering on a Doctrine2 DQL Query
I am just beginning to sell some of my images and would like to personalize them a little.  Many photographers sign and title their work on the white space just below the printed image. I am having metal prints made so there is no matting or white space, so I considered printing small (2"x3.5") stickers to place on the back of the images. What information do you think should be included on that sticker? Pretty much everything I've found online talks about a certificate of authenticity and limited editions. I do not want limited editions but would like to sign and number my larger prints. Does anyone have experience with this? Do I need to print a separate certificate? At this juncture my sticker will have my logo, image title, artist name (me), place for my signature and date, "edition #xx of an open edition". Some sites mention including the date the photograph was taken; format (i.e. 24"x36" photographic print on metal), though it seems redundant since it will be on the back of the print; same goes for description of artwork, as well as copyright as I am signing and dating it. I do plan on printing a second sticker with care instructions (i.e. hang indoors and out of direct sunlight etc.).  

Revision to clarify:
What information should be included? Do I need to put copyright information if I am signing it? Is it necessary to include the format of the print or the shot on date?  Should I also be providing a certificate of authenticity?

Thank you!
