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