CREATE TABLE customer (

    name TINYTEXT NOT NULL,

    FULLTEXT (name)

) ENGINE = InnoDB;

INSERT INTO customer VALUES ('O''Brien');

SELECT * FROM customer WHERE MATCH (name) AGAINST ("+O'Brien" IN BOOLEAN MODE);

Empty set (0.000 sec)

CREATE TABLE customer2 (

    name TINYTEXT NOT NULL,

    FULLTEXT (name)

) ENGINE = Aria;

INSERT INTO customer2 VALUES ('O''Brien');

SELECT * FROM customer2 WHERE MATCH (name) AGAINST ("+O'Brien" IN BOOLEAN MODE);

1 row in set (0.001 sec)

CREATE TABLE customer3 (

    name TINYTEXT NOT NULL,

    FULLTEXT (name)

) ENGINE = MyISAM;

INSERT INTO customer3 VALUES ('O''Brien');

SELECT * FROM customer3 WHERE MATCH (name) AGAINST ("+O'Brien" IN BOOLEAN MODE);

1 row in set (0.001 sec)