1. 论坛系统升级为Xenforo,欢迎大家测试!
    Dismiss Notice

请教一个批量修改字段SQL语句

Discussion in '后端开发' started by ken27, Apr 12, 2007.

  1. ken27

    ken27 New Member

    Joined:
    Dec 10, 2005
    Messages:
    3
    Likes Received:
    0
    普通的替换语句是这样吧?

    Code:
    update 表名称 set 字段名称=REPLACE(字段名称,'原数据','新数据')

    现在我想将

    "[这里是随机字符,精彩文章]" 替换成 "推荐内容"

    应该怎样写SQL语句呢?不知道这符号 [] 和随机字符怎样处理,请高手指点一下 :lol:
     
    #1 ken27, Apr 12, 2007
    Last edited: Apr 16, 2007
  2. hjb1

    hjb1 Active Member

    Joined:
    Sep 4, 2005
    Messages:
    1,623
    Likes Received:
    5
    好像不行的 -_-~

    我顶~ 因为我也想要~ 哈哈:)
     
    #2 hjb1, Apr 12, 2007
    Last edited: Apr 12, 2007
  3. feeless

    feeless New Member

    Joined:
    Feb 27, 2007
    Messages:
    212
    Likes Received:
    0
    没看明白~~
     
  4. hjb1

    hjb1 Active Member

    Joined:
    Sep 4, 2005
    Messages:
    1,623
    Likes Received:
    5
    1. [随机112123]
    2. [随机sdfafggfsf]
    3. [随机23r42fg35t]
     
  5. ken27

    ken27 New Member

    Joined:
    Dec 10, 2005
    Messages:
    3
    Likes Received:
    0
    不明楼上的想表达什么。。。:mummy: