Skip to content

Instantly share code, notes, and snippets.

Avatar

Ercüment Şahin aecsahin

  • -
  • Turkey
View GitHub Profile
@aecsahin
aecsahin / qtranslate_cleanup.sql
Created Sep 5, 2019 — forked from frnhr/qtranslate_cleanup.sql
clean database after qTranslate uninstall
View qtranslate_cleanup.sql
# QTRANSLATE CLEANUP QUERIES
# create temp column to separate post content on <!--more--> tag to simplify queries
ALTER TABLE `wp_posts` ADD `tmp_excerpt` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
# split content
## fill `tmp_exceprt` column
UPDATE wp_posts SET tmp_excerpt =