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