SELECT * FROM `tablename` group by field_title having count(`id`) > 1 Advertisements
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 … More How to change WordPress theme directly from database?
After install XAMPP in Ubuntu sometime phpMyAdmin display in German language. You can change this language and set another language. Following code shows you to change the phpMyAdmin language to English in Ubuntu OS.