Skip to content

Instantly share code, notes, and snippets.

View aecsahin's full-sized avatar
🎯
Focusing

Ercument Sahin aecsahin

🎯
Focusing
View GitHub Profile
@aecsahin
aecsahin / qtranslate_cleanup.sql
Created September 5, 2019 20:15 — forked from frnhr/qtranslate_cleanup.sql
clean database after qTranslate uninstall
# 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 =