table data restructure

[bdichiara]

I'm going to restructure some of the data in my database to run smoother. Currently, I have many rows in my database in with a field called "location" in this format:

link[234]

or

kb[76]

or

search[something in something]

basically, I guess i need 3 separate update queries that will get rid of the part before the "[" along with the "[" and the "]" on each of these rows?

Can someone help me with this query?

_______________
_brian.

 

[r937]

just one query will do

update yourtable
   set yourcolumn =
        substring(yourcolumn
          , instr(yourcolumn,'[')+1
          , length(yourcolumn)
           -instr(yourcolumn,'[')-1 )

r937.com | rudy.ca

 

[bdichiara]

awesome, rudy, that did the trick! thanks!

_______________
_brian.