Results 1 to 4 of 4

Thread: insert string

  1. #1
    Join Date
    Jun 2011
    Posts
    2

    Unanswered: insert string

    hello my friend... i want to ask:
    how to insert the string,but not change the string position ?
    example:

    i want to insert in the left position

    "abc" in " test"

    the results "abc test"

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    UPDATE mytable SET mycolumn = concat("abc", mycolumn)
    WHERE something = somevalue
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2011
    Posts
    2

    insert

    sorry my friend my problem is how iam insert the some string but not change the position that string:

    exm:
    1. insert "abc" in " example" => the result "abcexample"
    or
    2. insert "abc" in "example" => the result "abcmple"

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ? don't understand what you are trying to achieve
    you could do it in SQL
    you could do it in your front end
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •