CodeLobster IDE
http://codelobster.com/forum/

How to delete record which begin with a certain value withi
http://codelobster.com/forum/viewtopic.php?f=3&t=24224
Page 1 of 1

Author:  sheilaanderson [ Thu Apr 12, 2018 6:33 am ]
Post subject:  How to delete record which begin with a certain value withi

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.

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/