MySQL – Delete Command

freeflow · 08-22-2008, 02: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, 02:22 PM

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

**Eric** · 08-22-2008, 03: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, 03:50 PM

At least perform a select before the delete...

Bruce_KD · 08-22-2008, 03: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, 02:07 PM	#1 (permalink)
freeflow NamePros Member Join Date: Dec 2006 Posts: 135 12.00 NP$ (Donate)	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:26 PM	#3 (permalink)
Eric NPQ's PA, Slave, and On Call Coder Technical Services Join Date: Mar 2005 Posts: 4,545 0.71 NP$ (Donate)	I'd recommend making a database backup first. You never know, you may end up deleting more than you want to __________________

08-22-2008, 03:50 PM	#4 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 6,284 1,095.94 NP$ (Donate)	At least perform a select before the delete... __________________ Buy now - MassDeveloper.com $500

08-22-2008, 03:52 PM	#5 (permalink)
Bruce_KD NamePros Member Join Date: Sep 2006 Posts: 87 100.00 NP$ (Donate)	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, 02:22 PM	#2 (permalink)
RJ NamePros Founder Administrator Join Date: Feb 2003 Location: Bay Area, CA Posts: 13,173 104,201.68 NP$ (Donate)	mysql_query("DELETE FROM guestbook WHERE Text LIKE '%http%'");

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

Administrator

Technical Services