Tag Archives: database

Difference between joomla and drupal

Comparison¬† between joomla and drupal is a complex topic. Users of both CMS claims that they are the best. Now, Without wasting time let me show you the tabular difference between joomla and drupal. If anybody feels to add few … Continue reading

Posted in Development | Tagged , , , , , , | Leave a comment

Replace space to hyphen in MySql

phpmyadmin_csv_upload_4

Again, I am publishing another mysql query to replace the space with the hyphen. also Below is the replace space to hyphen in MySql Query:- SELECT `id` , name, REPLACE( LCASE( name ) , ‘ ‘, ‘-‘ ) AS alias1 … Continue reading

Posted in Development, MySql | Tagged , | 1 Comment

Finding non-duplicate records from different MySql Tables

SQL Query For DeDuplication of Records

I was searching for the solution to match two database table with same or different fields and remove the data which is present in both tables. After goggling a lot, I realize find and remove duplicate records in mysql is … Continue reading

Posted in Development, MySql | Tagged , , , , | 7 Comments