Ninjakreborn Posted February 9, 2011 Share Posted February 9, 2011 Is there any way to use ONE alias, along with the standard wildcard. In theory I would think 'products.product_id_number AS product_id, *' That should get the product_id as product_id_number as product_id, then get the rest of them like normal. Is there any way/syntax to perform this action? Quote Link to comment Share on other sites More sharing options...
requinix Posted February 9, 2011 Share Posted February 9, 2011 SELECT products.product_id_number AS product_id, * FROM products... So yeah, you got it right. Quote Link to comment Share on other sites More sharing options...
Ninjakreborn Posted February 10, 2011 Author Share Posted February 10, 2011 No, that was an example of what I tried. That throws a syntax error. Quote Link to comment Share on other sites More sharing options...
Maq Posted February 10, 2011 Share Posted February 10, 2011 No, that was an example of what I tried. That throws a syntax error. What's the error? Quote Link to comment Share on other sites More sharing options...
ale8oneboy Posted February 10, 2011 Share Posted February 10, 2011 In my experience I've had to use the alias on the wild card too. Try: SELECT products.product_id_number AS product_id, products.* FROM products Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.