Jump to content

Archived

This topic is now archived and is closed to further replies.

phpsqlprogrammer

How do I mass delete entries with a certain value in a...

Recommended Posts

How do I mass delete entries with a certain value in a particular column?

 

Hi, thanks for answering in advance.

 

How do I mass delete all entries that has a value, say 123.123.com under the column \"remotehost\" in a table? Any SQL query that fits my description??

 

You see, this is a counter script and I am trying to remove all the counts that belong to me.

 

Thanks. :]

Share this post


Link to post
Share on other sites

This code will delete the entries which belongs to \"123.123.com\"

 

delete from <table-name> where remotehost=\'123.123.com\'

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.