I have database that has product table. I want to delete any product that has certains "keyword" in the product title from the databse.
I also want to keep the Product id intact. so that each product still has it original product id.
I need the sql so i can test it and impliment it myself as I do not want to ruin my database
23 freelancers are bidding on average $20 for this job
hello, can you export the database and to test it in other place? to be sure that we are not ruining anything? i have experience on working with mysql. Best regards, Beny
You should be able to: DELETE FROM product_table WHERE title LIKE '%keyword%' If you have multiple keywords: DELETE FROM product_table WHERE title LIKE '%keyword%' OR title LIKE '%keyword%' And so on
Hi Greeting, I am interested in this project. having good experience in MySQL and mongo DB database. Please let me know about your thought. I can do this task. Thanks. Regards, Dinesh khanter.
Hello there, I can help you with sql, can you pls provide some database schema and exact instructions what needs to be deleted. Best Regards, Aleksandar Markovic.
We have more than one year of industrial experience on working with the SQL commands. we can done this project to you with the best price with the minimum time.