Can i use double quotes in mysql?

Using Backticks, Double Quotes, and Single Quotes when querying a MySQL database can be boiled down to two basic points.

  1. Quotes (Single and Double) are used around strings.
  2. Backticks are used around table and column identifiers.

Double Quotes

Using double quotes here is some input and output examples:

SELECT "test", "'test'", "''test''", "te""st";

The output looks like this:

Can i use double quotes in mysql?

Wrapping single quotes inside of double quotes will cancel out the expected behavior of the single quotes in the MySQL Query and instead treat it as part of the string. This can be seen in columns 2 and 3 in the example above.

Inserting two double quotes in the middle of the string will cancel out one of them.

Single Quotes

Using single quotes here is some input and output examples:

SELECT 'test', '"test"', '""test""', 'te''st';

The output looks like this:

Can i use double quotes in mysql?

As shown in the demonstration above, single quotes behave the same way as double quotes in these contexts.

Using Single Quotes and Double Quotes Together

Often times there will be a contraction in a string, or a direct quote. In situations like in NPS survey reports or other customer feedback forms this is often the case. In these cases using double quotes to wrap a text string that contains a contraction like They’ve will keep the single quote in the string as an apostrophe.

In this case presenting a string with a contraction should look like this:

SELECT "They've found this tutorial to be helpful"

The output looks like this:

Can i use double quotes in mysql?

Or, if you need to use double quotes to present a customer feedback quote in the string, you can use single quotes to wrap the whole string.

SELECT 'They responded, "We found this tutorial helpful"'

If you need to use single quotes and double quotes in a string that contains both a contraction and a quote, you will need to use the backslash ‘' to cancel out the following character. For example: a string containing this ' will recognize the backslash as an instruction to cancel out the single quote’s syntactical meaning and instead insert it into the string as an apostrophe.

SELECT 'They\'ve responded, "We found this tutorial helpful"'

Can i use double quotes in mysql?

Backticks

Backticks are used in MySQL to select columns and tables from your MySQL source. In the example below we are calling to the table titled Album and the column Title. Using backticks we are signifying that those are the column and table names.

    SELECT `Album`.`Title`
    FROM `Album` AS `Album`
    GROUP BY `Album`.`Title`
    ORDER BY `Title` ASC
    LIMIT 10;

The backticks for column names may not be necessary though.

    SELECT Album.Title
    FROM Album AS Album
    GROUP BY Album.Title
    ORDER BY Title ASC
    LIMIT 10;

Both of these queries will return the same result.

Can i use double quotes in mysql?

Putting it all together

The following query will use all we’ve learned here, including double quotes, single quotes, and backticks.

SELECT 'They\'ve responded, "We found this tutorial helpful"' as `Response`

Will return:

Can i use double quotes in mysql?

Can you use double quotes in SQL?

Double quotes generally aren't used in SQL, but that can vary from database to database. Stick to using single quotes. That's the primary use anyway..
Double quotes are usually used to object names (e.g. column name "First name"). ... .
No. ... .
158. ... .
You should use double quotes for identifiers..

When should I use quotes in MySQL?

QUOTE() : This function in MySQL is used to return a result that can be used as a properly escaped data value in an SQL statement. The string is returned enclosed by single quotation marks and with each instance of backslash (\), single quote ('), ASCII NULL, and Control+Z preceded by a backslash.

How do I save double quotes in MySQL?

So if you want to display double quotes in your result, wrap them inside single quotes. If you need to display single quotes in a string and also wrap them in single quotes, then you need to escape the inner single quotes using backslash (\) as shown below.

How do you write a double quote in SQL query?

sorry - but SQL should be the same - just differences in function name. – MikeyKennethR. Jun 6, 2011 at 15:00..
Only works in sql 2012, 2008 doesn't have the concat function. – Fourth. ... .
Being pedantic but OP wanted double quotes so in SQL Server its: Select Concat('"',[First],'","',[Last],'","',[Email],'"') – HostMyBus..