Find duplicate records in MySQL

SELECT * FROM `tablename` group by field_title having count(`id`) > 1

Advertisements

How to change WordPress theme directly from database?

Sometime you want to change WordPress theme without login in site backend. For example If you upgrade wordpress site and after complete upgradation of site you found that site is stop working. You may see just a blank page instead of newly updated site. This situation may happen if your old theme not support the newly upgraded WordPress. If this happen you may lost access of site frontend as well as backend also. In this case if you have access of database then you can change the current wordpress theme using MySQL query. Continue reading “How to change WordPress theme directly from database?”