On Jun 29, 2005, at 8:47 AM, jbv wrote:
Trevor,Thanks, but I found the solution in the mySQL manual about an hour ago... I was actually confusing the Postgres and mySQL syntax... stupid me... However, why did you add "as myCol" ? I'm using : SELECT concat("$",ID,"$"), col_1, col_2 FROM myTable WHERE id < 100
If you are going to be dealing with your columns by name when working with the results then myCol is easier to write than concat ("$",ID,"$") which is what the column would be named without the "as myCol".
-- Trevor DeVore Blue Mango Multimedia [EMAIL PROTECTED] _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
