mysql - SQL query to remove text within parentheses? -


What is the best SQL query to delete any text within a mysql database? I want something that works in the beginning of the text regardless of the condition of the bracket (beginning, middle, end, whatever). I do not care about putting the text inside the brackets, just removing it.

Thank you!

I thought it: 

  Table Set Column = CONCAT (SUBSTR (Column, 1, Locate ('(', 'Column' -1 '), SUBSTR (Column, Locate (') ', Column) +1) Update' Column ('%' Works for purposes, but it builds the following beliefs: 
 
     
  •  The brackets are matching correctly 
    •  
      
  •  only in the string A pair bracket exists (no nesting, etc.) 
    •

Comments

Post a Comment