Compare values in SQL having dots
You can try to use replace function:

mysql&gt; select replace("A.B C", ".", "") = "AB C";
+------------------------------------+
| replace("A.B C", ".", "") = "AB C" |
+------------------------------------+
|                                  1 |
+------------------------------------+
1 row in set (0.00 sec)