mysql - SQL select AS - 前置文本

Question

是否可以将文本添加到 SQL select 语句中。例如:

var query = "SELECT id, " +
                   "picture " 
            "FROM people";

至

var query = "SELECT id, " +
                   "picture AS './directory/' + picture "
            "FROM people";

Answer 1

是的。像这样的事情:

  var query = "SELECT id, " +
              "concat('./directory/',picture) AS  picture "
              "FROM people";

更多详细信息:http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat