remove special characters mysql

Solutions on MaxInterview for remove special characters mysql by the best coders in the world

showing results for - "remove special characters mysql"
Jacob
19 Aug 2020
1usertable
2+----+-----------+
3| Id | Name      |
4+----+-----------+
5|  1 | $John     |
6|  2 | $Carol    |
7|  3 | $Mike     | 
8|  4 | $Sam      |
9|  5 | $Dav$id$  |
10|  6 | Robert$   |
11|  7 | J$ames$   |
12|  8 | Max$well$ |
13+----+-----------+
148 rows in set (0.00 sec)
15
16#Update table by replacing "$" with "" (nothing).
17update usertable
18set Name=replace(Name,'$','');
19
20Query OK, 8 rows affected (0.22 sec)
21Rows matched: 8 Changed: 8 Warnings: 0
22
23#Query table to confirm changes.
24SELECT *
25FROM usertable
26
27+----+---------+
28| Id | Name    |
29+----+---------+
30|  1 | John    |
31|  2 | Carol   |
32|  3 | Mike    |
33|  4 | Sam     |
34|  5 | David   |
35|  6 | Robert  |
36|  7 | James   |
37|  8 | Maxwell |
38+----+---------+
398 rows in set (0.00 sec)
40
41