Use alias for column output of report?

Viewing 1 replies (of 1 total)
  • Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    An example of a real field name of “post_author”:

    SELECT post_author FROM wp_posts

    An example of a real field name of “post_author” and an alias of “author”:

    SELECT post_author AS author FROM wp_posts

    As you can see, an alias is what MySQL passes back from the SELECT, and the real field name is the actual field name or MySQL evaluation (like a CONCAT or whatever it may be) behind the alias passed back from MySQL.

Viewing 1 replies (of 1 total)
  • The topic ‘Use alias for column output of report?’ is closed to new replies.