Delete not deleting.

[mickeymouse 0]

$query = "DELETE * FROM names WHERE `Ref` = '$ref' ";

`Ref` is field 0 in my Database and I have an item whose `Ref` is "0001"

and my $ref = "0001".

But my item is not getting deleted.

The  $AffectedRows = -1

There are no error messages.

What is wrong with my $query statement?

Tks

[mickeymouse 0]

OK.  Found my problem.

It was the asterisk "*" which I had after the word DELETE.

I thought I needed the "*" to signify delete all if more than one with the same criteria.

Thank you.