SELECT COL_TO_CHECK, COUNT(COL_TO_CHECK) FROM table1 GROUP BY COL_TO_CHECK HAVING COUNT(*) > 1 ORDER BY COUNT(*) If there is more than 1 column with that value it will show up like: COL_TO_CHECK COUNT(COL_TO_CHECK) ————————————————————- Value 3 Value2 2 Value99 4
mysqli is a built in part of mysql 4.1. It incorporates all functionality required to interact with a database from your PHP file. It has basics like querying the database, which includes SELECTing data as well as INSERTing data. It also give the ability to use prepared statements, transactions which can be committed or rolled… Read More »