Removing MySQL rows from a table using SQL Query

1149705 pts.
Tags:
MySQL
SQL Query
In MySQL, I have a table that currently holds the following topics:
id
url
title
company
site_id
So I have to go in and remove the rows that have the same title, company and Site_ID. Can this be done using a SQL Query? Thank you!
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Should be fairly easy. What does your code look like? It sounds like a homework task.
    134,720 pointsBadges:
    report
  • carlosdl
    Yes, it is possible, but you would have to tell us how you want to do it because a decision needs to be made as to which one of the rows is kept when a duplicate is found.
    85,055 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: