sunnyblik (sunnyblik) wrote,
sunnyblik
sunnyblik

Category:

Mysql - частые команды

Поиск и замена:
UPDATE articles SET text = REPLACE(text, '8-927-123-45-67 - старое значение', '8-927-123-76-54 - новое')
WHERE text LIKE '%8-927-123-45-67
- старое значение%'
Tags: mysql
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments