jimmyoneshot Posted October 23, 2011 Share Posted October 23, 2011 Quick question. I need to select the same thing as 2 things and I'm wondering if there is a shorthand to basically do this:- SELECT photos.id AS photoId AND itemId, photos.name, photos.author_id FROM photos OR is there no shorthand for this and will it need to be done as:- SELECT photos.id AS photoId, photos.id AS itemId, photos.name, photos.author_id FROM photos Link to comment https://forums.phpfreaks.com/topic/249636-select-as-2-things/ Share on other sites More sharing options...
awjudd Posted October 23, 2011 Share Posted October 23, 2011 There is no shorthand. You need to split it out. ~juddster Link to comment https://forums.phpfreaks.com/topic/249636-select-as-2-things/#findComment-1281527 Share on other sites More sharing options...
jimmyoneshot Posted October 23, 2011 Author Share Posted October 23, 2011 Ok thanks juddster Link to comment https://forums.phpfreaks.com/topic/249636-select-as-2-things/#findComment-1281534 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.