[WordPress] SyntaxHighlighter를 Enlighter로 변경하는 SQL

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush:bash">',
    '<!-- wp:enlighter/codeblock {"language":"shell"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="shell" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush: bash">',
    '<!-- wp:enlighter/codeblock {"language":"shell"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="shell" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush:ps">',
    '<!-- wp:enlighter/codeblock {"language":"bat"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="bat" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush: ps">',
    '<!-- wp:enlighter/codeblock {"language":"bat"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="bat" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush:java">',
    '<!-- wp:enlighter/codeblock {"language":"java"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="java" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush:c">',
    '<!-- wp:enlighter/codeblock {"language":"c"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="c" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush:perl">',
    '<!-- wp:enlighter/codeblock {"language":"generic"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="generic" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush:js">',
    '<!-- wp:enlighter/codeblock {"language":"javascript"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="javascript" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush:sql">',
    '<!-- wp:enlighter/codeblock {"language":"sql"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="sql" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush: sql">',
    '<!-- wp:enlighter/codeblock {"language":"sql"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="sql" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush:xml">',
    '<!-- wp:enlighter/codeblock {"language":"xml"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="xml" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush:html">',
    '<!-- wp:enlighter/codeblock {"language":"html"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="html" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush: html">',
    '<!-- wp:enlighter/codeblock {"language":"html"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="html" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush:css">',
    '<!-- wp:enlighter/codeblock {"language":"css"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="css" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '<pre class="brush:php">',
    '<!-- wp:enlighter/codeblock {"language":"php"} -->\n<pre class="EnlighterJSRAW" data-enlighter-language="php" data-enlighter-theme="" data-enlighter-highlight="" data-enlighter-linenumbers="" data-enlighter-lineoffset="" data-enlighter-title="" data-enlighter-group="">'
  )
where post_content like '%<pre class=%';

UPDATE hasu0707.wp_posts
SET
  post_content = REPLACE(
    post_content,
    '</pre>',
    '</pre>\n<!-- /wp:enlighter/codeblock -->'
  )
where post_content like '%<pre class=%';