<div>
Qlemo is correct for the explanation. so for your example, you should do this:<br />

<pre><code id="code-20-41035289-1">INSERT INTO Table (Name,Value) VALUES ( 'nameString' , 'valueString' );
DELETE FROM Table WHERE Name= 'nameString' ;</code></pre>
<br />
if the string value itself contains a single quote, like a'mbuli, &nbsp;you can try:<br />

<pre><code id="code-20-41035289-2">INSERT INTO Table (Name,Value) VALUES ( 'nameString' , 'a''mbuli' );
DELETE FROM Table WHERE Value = 'a''mbuli' ;</code></pre>
</div>


Qlemo is correct for the explanation. so for your example, you should do this:


INSERT INTO Table (Name,Value) VALUES ( 'nameString' , 'valueString' );
DELETE FROM Table WHERE Name= 'nameString' ;


if the string value itself contains a single quote, like a'mbuli,  you can try:


INSERT INTO Table (Name,Value) VALUES ( 'nameString' , 'a''mbuli' );
DELETE FROM Table WHERE Value = 'a''mbuli' ;

<div>
<div class="content wysiwyg-content">
Hi there,<br />
I have to insert and delete some data using names that may contain single or double quotes.<br />
<br />
<br />
INSERT INTO Table (Name,Value) VALUES (' &quot;nameString&quot; ', ' &quot;valueString&quot; ');<br />
DELETE FROM Table WHERE Name= &quot;nameString&quot;;<br />
<br />
When nameString has a single Quote like, a'mbuli, then I replace the single quote with two single quotes like (a''mbuli) and it works.<br />
<br />
But, how can I handle a double quote for example, a&quot;mbuli <br />
<br />
Thank you.
</div>
</div>


Hi there,
I have to insert and delete some data using names that may contain single or double quotes.


INSERT INTO Table (Name,Value) VALUES (' "nameString" ', ' "valueString" ');
DELETE FROM Table WHERE Name= "nameString";

When nameString has a single Quote like, a'mbuli, then I replace the single quote with two single quotes like (a''mbuli) and it works.

But, how can I handle a double quote for example, a"mbuli 

Thank you.

SQL handling single and double quotes

C is a general-purpose, imperative computer programming language, supporting structured programming, lexical variable scope and recursion, while a static type system prevents many unintended operations. By design, C provides constructs that map efficiently to typical machine instructions, so it has found lasting use in applications that had formerly been coded in assembly language, including operating systems as well as various application software for computers ranging from supercomputers to embedded systems. It is distinct from C++ (which has its roots in C) and C#, and many later languages have borrowed directly or indirectly from C.

C++ is an intermediate-level general-purpose programming language, not to be confused with C or C#. It was developed as a set of extensions to the C programming language to improve type-safety and add support for automatic resource management, object-orientation, generic programming, and exception handling, among other features.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.