SQL Syntax for deleting entries

[freeflow]

I would like to clean up my database, but I need some help with the syntax for the SQL commands.

Table: Domains2
Column: domainNames
Column: status

1. How can I delete duplicate entries? (domainNames)
2. How can I delete all entries with 1 – 3 letters? (domainNames)
3. How can I delete all entries that have the status “CLIENT UPDATE PROHIBITED”? (status)

Thanks for your help.

 

[sote]

Remember to backup your database before trying this out.

For 1 just add a unique index on the domainNames column.

For 2 use:

DELETE FROM `Domains2` WHERE CHAR_LENGTH(domainNames)<4

For 3 use this:

DELETE FROM `Domains2` WHERE status LIKE '%CLIENT UPDATE PROHIBITED%'

 

[freeflow]

For 2 use:

DELETE FROM `Domains2` WHERE CHAR_LENGTH(domainNames)<4

Thanks for your help. Code number 2 is not deleting the entries with
three or less characters. Is it case sensitive?

 

[weblord]

just use this:

DELETE FROM `Domains2` WHERE CHAR_LENGTH(domainNames)<1