Greenguy's Board - View Single Post

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!

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!