I have a table called Customer containing Id, Firstname, Lastname, Phone as their respective columns.
Now I want to delete an entry from the table Using Fullname.
DELETE FROM customer
WHERE exists (SELECT * Id,CONCAT(Firstname," ",Lastname) as wholename
from customer where wholename ="Andre Russel");
DELETE FROM customer WHERE CONCAT(Firstname,' ',Lastname) = 'Andre Russel'