CodeLobster IDE http://codelobster.com/forum/ |
|
How to delete record which begin with a certain value within http://codelobster.com/forum/viewtopic.php?f=3&t=6192 |
Page 1 of 1 |
Author: | congay2014 [ Fri Sep 26, 2014 6:54 pm ] |
Post subject: | How to delete record which begin with a certain value within |
I've got a table named "Alias" , now I want to delete all records which begin with "tq=" within the "code" field. For example.. if there is a record with: tq=4 in the "code" field, the record has to be deleted. if there is a record with: ga=3 in the "code" field, the record may not be deleted. I don't know how to do this, I have googled a while without result. Hopefully one of you guy's can help me with getting the sql coding. |
Author: | Admin [ Mon Sep 29, 2014 6:27 am ] |
Post subject: | Re: How to delete record which begin with a certain value wi |
Hi. Try something like that: DELETE FROM 'Alias' WHERE 'code' LIKE 'tq=%' Regards, Codelobster Team. |
Author: | tinajone [ Sun Dec 24, 2017 7:56 am ] |
Post subject: | Re: How to delete record which begin with a certain value wi |
I am also in this case, can you explain it to me. |
Page 1 of 1 | All times are UTC |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |