SQL - delete string inside of cell, not row.

**dubstar** · May 3rd, 2006

Any way to search and remove a string in the column and just delete it (the string) instead of deleting the entire cell or worse, the entire row??

**X-Istence** · May 4th, 2006

UPDATE <table> SET collumn = "" WHERE othercollumn = "Some string here"

**dubstar** · May 11th, 2006

nice. thanks brotha man.

May 3rd, 2006	Top \| #1
dubstar format c: Joined: December 2002 Location: Southern California Posts: 1,358 Reputation: 50 Power: 129	SQL - delete string inside of cell, not row. Any way to search and remove a string in the column and just delete it (the string) instead of deleting the entire cell or worse, the entire row?? QuistPro: 13" macbook pro. mid 2009. 10.6.4 box360: xbox 360 elite apple airport extreme / fios / 10mb/2mb retired: nerdBox: a7n8x-d / xp pro / 2800 athlon xp quistBox: xbox 1.6b / 250g / xenium ice mod-chip quistServ: dell pEdge 600sc / 2k3 blackthorne: dell e1505 / mce / 1.83 duo iQuist: White 3g iPhone / 16g / jailbroken / unlocked TMobile quistMobile: tmobile mda quistMobile2: htc g1

May 4th, 2006	Top \| #2
X-Istence * Joined: December 2001 Location: USA Posts: 6,496 Reputation: 2808 Power: 220	Re: SQL - delete string inside of cell, not row. UPDATE <table> SET collumn = "" WHERE othercollumn = "Some string here" An engineers technical notebook

May 11th, 2006	Top \| #3
dubstar format c: Joined: December 2002 Location: Southern California Posts: 1,358 Reputation: 50 Power: 129	Re: SQL - delete string inside of cell, not row. nice. thanks brotha man. QuistPro: 13" macbook pro. mid 2009. 10.6.4 box360: xbox 360 elite apple airport extreme / fios / 10mb/2mb retired: nerdBox: a7n8x-d / xp pro / 2800 athlon xp quistBox: xbox 1.6b / 250g / xenium ice mod-chip quistServ: dell pEdge 600sc / 2k3 blackthorne: dell e1505 / mce / 1.83 duo iQuist: White 3g iPhone / 16g / jailbroken / unlocked TMobile quistMobile: tmobile mda quistMobile2: htc g1

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
C++: cant resolve string --> string[]	dubstar	Web Design & Coding	6	May 27th, 2007 8:10am
Search string length	SPeedY_B	Site Problems & Feedback	6	January 14th, 2004 4:42am
Visual Basic String Manipulation	cpugeniusmv	Web Design & Coding	8	April 28th, 2003 11:36pm
modem string	bluzeboy	Windows Desktop Systems	2	November 22nd, 2002 2:49pm
modem string	bluzeboy	Windows Desktop Systems	3	September 20th, 2002 2:08am