MySql error - 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's*' IN BOOLEAN MODE) ORDER BY MATCH(pro_descripcion) AGAINST('*teys's*' IN' at line 11
Sentencia SQL:: SELECT *, ROUND(pre_precio_publico,2) as 'pre_precio_publico', IF(pre_descuento_pami=0,'No Aplica',CONCAT('$ ',pre_descuento_pami,' PAC. $ ',pre_precio_pami_con_descuento)) as 'cobertura_pami', IF(pre_monto_ioma=0 OR pre_monto_ioma IS NULL,'No Aplica', CONCAT('$ ',pre_monto_ioma,' PAC. $ ',pre_precio_ioma_con_descuento)) as 'cobertura_ioma', IF((pre_codigobarras+0)=0,'Desconocido',pre_codigobarras) as 'pre_codigobarras' FROM tbl_main_prod WHERE MATCH(pro_descripcion) AGAINST('*teys's*' IN BOOLEAN MODE) ORDER BY MATCH(pro_descripcion) AGAINST('*teys's*' IN BOOLEAN MODE) DESC