Facing difficulty in removing the apostrophe in MySQL stored procedure?

To remove apostrophe, replace it. For this, you can use REPLACE(). Following is the syntax −

SET anyVariableName = REPLACE(yourVaribleName , '\'', '');

To understand the above syntax, let us create a stored procedure to remove the apostrophe in MySQL −

mysql> DELIMITER // mysql> CREATE PROCEDURE remove_Apostrophe(IN Value VARCHAR(200))    BEGIN       SET Value = REPLACE(Value , '\'', '');       SELECT CONCAT("AFTER REMOVING APOSTROPHE THE STRING IS= ", Value);    END    // Query OK, 0 rows affected (0.15 sec) mysql> DELIMITER ;

Call the stored procedure using CALL command −

mysql> CALL remove_Apostrophe("Introduction to My'SQL");

This will produce the following output −

+----------------------------------------------------------------+ | CONCAT("AFTER REMOVING APOSTROPHE THE STRING IS= ", Value)    | +----------------------------------------------------------------+ | AFTER REMOVING APOSTROPHE THE STRING IS= Introduction to MySQL | +----------------------------------------------------------------+ 1 row in set (0.00 sec) Query OK, 0 rows affected, 1 warning (0.01 sec)