So I have a huge list of entries in a DB (**MySql**)

I'm using **Python** and **Django** in the creation of my web application.

This is the base Django model I'm using:

```
class DJ(models.Model):
    alias = models.CharField(max_length=255)
    #other fields...

```

**In my DB I have** now **duplicates**

> 
> eg. *Above & Beyond*, *Above and Beyond*, *Above Beyond*, *DJ Above and Beyond*, 
>  *Disk Jokey Above and Beyond*, ...
> 
> 
> 

This is a problem... as it blows a big hole in my DB and therefore my application.

---

I'm sure other people have encountered this problem and thought about it.

My ideas are the following:

* Create a set of rules so a new entry cannot be created?

> 
> eg. **"DJ Above and Beyond"** cannot be
>  created because **"Above & Beyond"** is in
>  the DB
> 
> 
>
* Relate these aliases to each other somehow?

> 
> eg. relate **"DJ Above and Beyond"** to **"Above & Beyond"**
> 
> 
>

---

I have literally no clue how to go on about this, even if someone could point me into a direction that would be very helpful.

Any help would be very much appreciated! Thank you guys.