0

I have a table in mysql, there are two columns in this table 'ID' and 'Branch'. I want to make the fix the column 'Branch'

Structure:

ID    Branch
1     ?¤All-bank
2     (1) bank
3     ÂJohn & William
4     % Bank
5     ----Road one
6     ?bank

Output expected:

ID    Branch
1     All-bank
2     bank
3     John & William
4     Bank
5     Road one
6     bank

So basically the branch can contain english characters and some special characters like ".,/&-"

I was think on these lines:

SELECT * FROM table_name WHERE branch like '%[^a-zA-Z0-9]%'

Can anyone help me on this, mysql newbie here.

thanks a lot in advance

Hanxue
  • 12,243
  • 18
  • 88
  • 130
Anubhav Dikshit
  • 1,729
  • 6
  • 25
  • 48

0 Answers0