MySQL – Delete Command

freeflow · 08-22-2008, 03:07 PM

I am looking for the right command to delete all entries in my
guestbook that have a HTTP in them.

Can you correct this command?

mysql_query("DELETE FROM guestbook WHERE Text='%http%'");

Thanks.

RJ · 08-22-2008, 03:22 PM

mysql_query("DELETE FROM guestbook WHERE Text LIKE '%http%'");

Eric · 08-22-2008, 04:26 PM

I'd recommend making a database backup first. You never know, you may end up deleting more than you want to

sdsinc · 08-22-2008, 04:50 PM

At least perform a select before the delete...

Bruce_KD · 08-22-2008, 04:52 PM

You can also add limits to your deletion, such as

Code:

Delete From `table` where `row` LIKE '%Something%' limit 1

What happens if an error comes up and Something = Nothing?
Then it clears your database.
Using Limit # stops it from deleting too many. It also speeds up queries when dealing with large databases.

Bruce

08-22-2008, 03:07 PM	THREAD STARTER #1 (permalink)
freeflow NamePros Regular Join Date: Dec 2006 Posts: 236	MySQL – Delete Command I am looking for the right command to delete all entries in my guestbook that have a HTTP in them. Can you correct this command? mysql_query("DELETE FROM guestbook WHERE Text='%http%'"); Thanks.

08-22-2008, 03:22 PM	#2 (permalink)
RJ NamePros Webmaster Join Date: Feb 2003 Posts: 12,930 Follow @DomainBuyer	mysql_query("DELETE FROM guestbook WHERE Text LIKE '%http%'"); __________________ @DomainBuyer facebook

08-22-2008, 04:50 PM	#4 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 9,552	At least perform a select before the delete... __________________ NameNewsletter.com - free lists of available domain names ZoneFiles.net (beta) - ccTLD and gTLD droplists

08-22-2008, 04:52 PM	#5 (permalink)
Bruce_KD NamePros Member Join Date: Sep 2006 Posts: 99	You can also add limits to your deletion, such as Code: Delete From `table` where `row` LIKE '%Something%' limit 1 What happens if an error comes up and Something = Nothing? Then it clears your database. Using Limit # stops it from deleting too many. It also speeds up queries when dealing with large databases. Bruce __________________ Need a CAPTCHA? www.KingdomsDivided.com

08-22-2008, 04:26 PM	#3 (permalink)
Eric Senior Member Join Date: Mar 2005 Posts: 4,948	I'd recommend making a database backup first. You never know, you may end up deleting more than you want to

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)