MySQL – Delete Command

[freeflow]

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]

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

 

[Eric]

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

 

[Kate]

At least perform a select before the delete...

 

[Bruce_KD]

You can also add limits to your deletion, such as

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