DELETE with regex

[sastro]

Here is my table

 

CODE | NAME

001 | Mayhem

002 | 3434

003 | just1

.

.

.

How to delete record with no char ( In PHP !preg_match('/[a-z]/i',$str) ) based on field NAME? So the list will looks like

CODE | NAME

001 | Mayhem

003 | just1

.

.

.

 

Thank you in advanced

[mikosiko]

test first with a SELECT instead of DELETE to be sure it works ok  (it should)

 

SELECT * FROM table
WHERE NOT name REGEXP '[a-z]';

[sastro]

Ok, it works. Also

DELETE FROM table WHERE name NOT REGEXP '[a-z]';

 

Thanks