Many times the use of single quote in the fields of the database gives us headaches, a simple solution is to use the thus selects:

SELECT REPLACE(nombre,””,’´’) as nombresincomilla,nombre FROM tabla

In this example we see that the result in a column to replace the single quote by the accent, avoiding problems
Another solution is to replace the fields with the single quote by accent:

UPDATE tabla SET nombre= REPLACE(nombre,””,’´’) WHERE nombre LIKE ‘%”%’

Facebooktwittergoogle_plusredditpinterestlinkedinmail