SQL Statement help

CelticTiger · 2007-11-20, 11:34 AM

I've been trying to delete some links from my database using the following statement:

DELETE FROM `links` WHERE (SELECT * FROM `links` WHERE `url` LIKE '%domain%')

but get the following error:

"Operand should contain 1 column(s)"

Can anyone tell me where I'm going wrong?

Thanks!

HowlingWulf · 2007-11-20, 03:06 PM

Why do you have SELECT in there?
Should be more like

DELETE FROM `links` WHERE `url` LIKE '%domain%';

CelticTiger · 2007-11-20, 03:42 PM

Yeah - tried that and was getting an error with that one too....so figured I needed a subquery.

Useless · 2007-11-20, 07:58 PM

Wouldn't the simplist solution be
delete from 'links' where 'url' = 'whatever'

CelticTiger · 2007-11-20, 08:30 PM

It would if it was just one url

unfortunately there are about 1500 from one domain that I need to delete - plus many more domains will pop up I'm sure that will need the same treatment.

shunga · 2007-11-21, 06:59 AM

I would use this:

DELETE FROM links WHERE url LIKE '%domain%'

CelticTiger · 2007-11-21, 10:49 AM

I tried that before posting - no luck with it - which is why I tried using the subquery.

Does Sparky still frequent the board?

CelticTiger · 2007-11-21, 10:56 AM

I got it

shunga · 2007-11-21, 11:22 AM

Quote:

Originally Posted by CelticTiger

I tried that before posting - no luck with it - which is why I tried using the subquery.

MySQL can be quite pedantic with quotation marks.

Glad you could find the solution.

2007-11-20, 11:34 AM	#1
CelticTiger Are you sure this is the Sci-Fi Convention? It's full of nerds! Join Date: Feb 2004 Location: Ireland Posts: 266	SQL Statement help I've been trying to delete some links from my database using the following statement: DELETE FROM `links` WHERE (SELECT * FROM `links` WHERE `url` LIKE '%domain%') but get the following error: "Operand should contain 1 column(s)" Can anyone tell me where I'm going wrong? Thanks! __________________ Submissions Wanted!

2007-11-20, 03:06 PM	#2
HowlingWulf Me fail English? That's unpossible! Join Date: Dec 2003 Location: FL Posts: 1,381	Why do you have SELECT in there? Should be more like DELETE FROM `links` WHERE `url` LIKE '%domain%'; __________________ WordPress Porn directory theme => Maddos Create a Porn Tube => Video Pornster

2007-11-20, 03:42 PM	#3
CelticTiger Are you sure this is the Sci-Fi Convention? It's full of nerds! Join Date: Feb 2004 Location: Ireland Posts: 266	Yeah - tried that and was getting an error with that one too....so figured I needed a subquery. __________________ Submissions Wanted!

2007-11-20, 07:58 PM	#4
Useless Certified Nice Person Join Date: Oct 2003 Location: Dirty Undies, NY Posts: 11,268	Wouldn't the simplist solution be delete from 'links' where 'url' = 'whatever' __________________ Click here to purchase a bridge I'm selling.

2007-11-20, 08:30 PM	#5
CelticTiger Are you sure this is the Sci-Fi Convention? It's full of nerds! Join Date: Feb 2004 Location: Ireland Posts: 266	It would if it was just one url unfortunately there are about 1500 from one domain that I need to delete - plus many more domains will pop up I'm sure that will need the same treatment. __________________ Submissions Wanted!

2007-11-21, 06:59 AM	#6
shunga Operator! Give me the number for 911! Join Date: Dec 2005 Location: Loveland Posts: 131	I would use this: DELETE FROM links WHERE url LIKE '%domain%' __________________ Got an Asian site? ICQ: 355-26-288

2007-11-21, 10:49 AM	#7
CelticTiger Are you sure this is the Sci-Fi Convention? It's full of nerds! Join Date: Feb 2004 Location: Ireland Posts: 266	I tried that before posting - no luck with it - which is why I tried using the subquery. Does Sparky still frequent the board? __________________ Submissions Wanted!

2007-11-21, 10:56 AM	#8
CelticTiger Are you sure this is the Sci-Fi Convention? It's full of nerds! Join Date: Feb 2004 Location: Ireland Posts: 266	I got it __________________ Submissions Wanted!