Mass delete members in ExpressionEngine

Posted on September 10, 2013

I read over EE forums like ExpressionEngine Community Support and ExpressionEngine StackExchange, some people asking to delete 1000+ members. Which is much time consuming if deleting all those members from Control Panel. Here, I would like to share an easy way to delete mass members with single SQL query. (more…)

Read More

Search and Replace from another table in MySQL

Posted on March 29, 2013

In MySQL, its easy to find occurrence of a sub-string within string and replace all that occurrences with MySQL REPLACE() function like: Also, REPLACE() function works well with SELECT query. Here, I would like to share simple SQL with which one can find the occurrence of a string in a table and replace that string with the data of another table like:

Read More