Em Andamento

Need sql query to delete row from table

Hello,

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

Habilidades: MySQL, SQL

Ver mais: SQL Query, query table, delete, product table, sql keyword, simple delete query sql php, need sql query, sql test database, sql query sql query, delete row table grid view php, delete table sql, joomla delete row table, query sql retrieve tree table, sql delete, delete database table sql, sql 2005 delete row table, query display table names oracle sql, sql query database, can write queries sql envoriment need, delete product mysql, jsf component table delete row, net query sql mobile table example, mysql sql, product query, sql parent child table tree query

Acerca do Empregador:
( 26 comentários ) Madison, United States

ID do Projeto: #6057554

Premiar a:

childersc

Hello, Keep in mind my bid is negotiable. I would love the opportunity to discuss your project and get you all fixed up. I have been working with PHP and MySQL for over 10 years. I have also been working with CSS Mais

$30 USD em 1 dia
(12 Avaliações)
4.1

23 freelancers estão ofertando em média $20 para este trabalho

LearningNew

A proposal has not yet been provided

$24 USD em 1 dia
(22 Comentários)
6.1
truongnguyen86

Hi there, I'm expert on database field, let me help you with this. Pls share your table, also your data. Waiting for your feedback. Thank you

$30 USD in 0 dias
(32 Comentários)
5.4
cbbeny

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

$15 USD em 1 dia
(97 Comentários)
5.0
lokjaiswal12

Hello, I have one question, you want to delete the row which matches the given criteria, and you want product id of other products to be intact. Right ? Can you give me sql schema ? I can give you query in 5 min Mais

$10 USD in 0 dias
(25 Comentários)
5.0
oxyk

Hello, the task seems to be pretty easy to deliver. I can create such query for your to run on your products database by utilizing php (so you can run it from your browser) or if you want it can be just juery to run f Mais

$15 USD em 1 dia
(25 Comentários)
4.3
acronymsolutions

Hi, I have gone through your requirements.I am a DBA at CMM5 Level company since August 2010.I am working on MySql,SQL ,Oracle database, I can do your job confidently. I am very much Interested to do your work,Please r Mais

$24 USD in 0 dias
(11 Comentários)
4.0
webkings09

Dear Sir, We are interested in your project. CONTACT US FOR LIVE [url removed, login to view] we are new in freelancer but we have a team of developers and designers of more than 6 years of experience and knowing latest technologies. Y Mais

$13 USD em 1 dia
(4 Comentários)
3.7
GAnthonyMassie

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

$10 USD em 1 dia
(12 Comentários)
3.6
Azaddien

Aucune proposition n'a encore été fournie.

$25 USD in 0 dias
(8 Comentários)
3.6
khanter

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.

$25 USD em 1 dia
(3 Comentários)
3.2
SaifuMak

I can do it.. I am PHP MYSQL expet.... Please message me and we can discuss everything? Regards, Mak

$25 USD em 1 dia
(6 Comentários)
3.0
itbeamtech

Dear Customer, I have 7 years of experience in Mobile & Web Application development. I have worked for BlackBerry, Android, ios(iPhone), PhoneGap, Titanium, Sencha, etc. Currently I am running a small company Mais

$24 USD em 1 dia
(1 Comentário)
2.9
stevewordpress

Hi ..... I am an open source expert with having 5+ years of experience on PHP,MYSQLWordpress / Joomla / MagentoExtension Development / Magento Customization / Online affiliation/Prestashop/OSCommerceetc...And the thing Mais

$17 USD em 1 dia
(3 Comentários)
1.6
aleksamarkoni

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.

$30 USD em 1 dia
(1 Comentário)
1.5
sumeet7890

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.

$13 USD em 1 dia
(0 Comentários)
0.0
anshulj181

Hello I have gone thru your requirement and want to show my intrest regarding the same. I have a experience of 3 years in the field of sql, .net I also have a team of experienced members. My main motive is to provi Mais

$15 USD em 1 dia
(0 Comentários)
0.0
pramixfreelancer

Hello dear, Try this query. DELETE FROM table_name WHERE title like 'keyword'; If you have any problem, ask me anything.

$25 USD em 1 dia
(0 Comentários)
0.0
shallufreelancer

A proposal has not yet been provided

$20 USD em 1 dia
(0 Comentários)
3.4
Ciberos

Hello, the query you need I think is delete from "table name" where "table field" like %keyword% limit 1 I hope to help you with this :). If you want, assign me the project for payment... and thank you very mu Mais

$10 USD in 0 dias
(0 Comentários)
0.0
rezaansar1412

Hi, I know MySQL pretty well. Let me do this for you. I need access to your database. I'm waiting. Thanks.

$20 USD em 1 dia
(0 Comentários)
0.0