Remove db dublicates
Posted: Fri Oct 03, 2008 6:42 pm
Hello world, is there any example to remove from DB dublicated records?
Thank you
Thank you
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
You mean "all of the duplicated items" or "all of the duplicated items except one"?Arsench2000 wrote:Hello world, is there any example to remove from DB dublicated records?
Thank you
Code: Select all
SELECT DISTINCT (field)
FROM table
GROUP BY field