Compare values in SQL having dots I'm comparing values from two different database.
In one table the name is stored with dots(i.e A.B C) and in another table the same value is stored as AB C(i.e in second table none of the names contain dots)
In SQL how can I compare the values? Dot can come anywhere in the name.
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)