string content (a varchar column) like `Value <>'' ` should generate script like `Value <>'''' ` but the actual result is `Value <>'' ` Once executed, it will be inserted as a single quote.