bluemagix
10-20-2008, 02:14 AM
Hello,
I want to delete duplicate records from table
In my table i have field business_address which has 3 parts
1)business name
2)address
3)phone number divided by #
record will be
"XYZ Agency#XYZ Address line1|address line 2|adrss line3#12345"
now i want to check
"XYZ Agency#XYZ Address line1|address line 2|adrss line3#12345"
only this much part
ie first # and first | with each and every record in the DB.
and if i found same i want to keep only one record AND delete the others
what i have to do for this purpose?
should i use PHP array..
or any efficient way to do this?
I want to delete duplicate records from table
In my table i have field business_address which has 3 parts
1)business name
2)address
3)phone number divided by #
record will be
"XYZ Agency#XYZ Address line1|address line 2|adrss line3#12345"
now i want to check
"XYZ Agency#XYZ Address line1|address line 2|adrss line3#12345"
only this much part
ie first # and first | with each and every record in the DB.
and if i found same i want to keep only one record AND delete the others
what i have to do for this purpose?
should i use PHP array..
or any efficient way to do this?