I am rather new at SQL and need to remove all characters between '[' and ']' and leave the remaining string behind.
An example of what I am looking for is as follows:
[test]hi -> hi
I am assuming this is possible using a SQL command.
Asked
Active
Viewed 48 times
0
-
Are you asking how to transform data while `select`ing it, or do you want to update the data in-place? – user229044 Aug 02 '17 at 16:29
-
can you please expected output and actual input – TheGameiswar Aug 02 '17 at 16:31
-
2you should tag the dbms being used. – Vamsi Prabhala Aug 02 '17 at 16:31
-
I would like to update the data in place. – likwidmonster Aug 02 '17 at 16:31
-
VTC you have been asked to provide the dbms – paparazzo Aug 02 '17 at 16:34
-
I am using Sequel Pro to manage the database and then The MVC Framework Laravel that uses the database – likwidmonster Aug 02 '17 at 16:41