Hi all
I want my data to replace what is there if data exists instead of creating a new row.
I tried this
replace into contactdetails
(contactemail, emailsubject, dealershipdetails)
values
("Your Email Address", "Enquiry",
"Your Name, Address, Contact Numbers etc");
But this creates a new row if the data exists 🙁
Is there a command I am missing? Or will i have to check if data exists and if so delete it, and then command another insert query?
Thankyou!