locked
sql statement RRS feed

  • Question

  • User2014201474 posted

    inside databasetable

    the one of column name called "Logo"

    the data is Logo = logo.jpg

    add want to add some character in before the result

    last time my sql statement use in sql server show below

    strSql = "SELECT 'Logo\' +Logo AS Logo   "

    the result show in db

    was "Logo\logo.jpg"

    but in mysql in cannot show result like that? got any method can do like that?

    Wednesday, July 6, 2011 12:53 AM

Answers

  • User551462331 posted

    try this...

    strSql = "SELECT CONCAT('Logo\' , Logo) as Logo"

    hope this helps...

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 6, 2011 1:25 AM