[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: mysql duplicate records



Hello

You can take the value : "media rotana" with Id = 1 for example

and delete all values like this value and then insert the old value

you must put it in new table to finish the for or while loop

or if you want to take the duplicate hotel names you can search for this
value "media rotana%" and insert them in new table then you can delete them
from the old one

I hope this solution to be good for you.

Regards,
Abdulla



On Thu, Feb 17, 2011 at 10:28, Farhan khalid <farhan2kf@xxxxxxxxx> wrote:

>
>
> Hello,
>
> I have duplicate hotel names in my database like
>
> 1.media rotana
> 2.media rotana, barsha - dubai
> 3.media rotana barsha dubai
>
> another example
> 1.ramada inn hotel denver
> 2.ramada inn resorts denver
> 3.ramada inn tower and resorts denver
>
> As you can see these 3 hotels are same but we have duplicate records so can
> anyone tell me is it possible to make some php code to find duplicate
> hotels
> like these?
>
> Regards
> Farhan
>
> [Non-text portions of this message have been removed]
>
>  
>


[Non-text portions of this message have been removed]



------------------------------------

Are you looking for a PHP job?
Join the PHP Professionals directory Now!
http://www.phpclasses.org/jobs/
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php-objects/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/php-objects/join
    (Yahoo! ID required)

<*> To change settings via email:
    php-objects-digest@xxxxxxxxxxxxxxx 
    php-objects-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    php-objects-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/



[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux