0

I have a mysql table and some of the elements from the field, "title" have "( some text)". I want to remove the brackets portion of the text.

So

blah blah (blah) would turn into blah blah

How would I do this in SQL?

mu is too short
  • 426,620
  • 70
  • 833
  • 800
ehsangh
  • 311
  • 2
  • 6
  • 16

1 Answers1

0

you can use the replace function in MySQL 

select replace(replace(title,'(', ''),')','') as  title
from table

http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_replace

COLD TOLD
  • 13,513
  • 3
  • 35
  • 52
  • what is element? I never defined it. I just want to update the table. How would i do this without using element? Thanks – ehsangh Jun 09 '12 at 03:20
  • @sanghan element, title or whatever you have is the name of the column you are selecting from – COLD TOLD Jun 09 '12 at 03:22