Tutorial Gateway

MySQL QUOTE Function

by

MySQL QUOTE function is one of the String Function, which is used to return a string enclosed by a single quotation mark. Or you can use this to escape the data value i.e., backslash, single quote, ASCII NULL.

In this article, we will show you, How to write MySQL String QUOTE Function with an example.

MySQL QUOTE Syntax

The basic syntax of QUOTE of a string in MySQL is as shown below:

QUOTE(String_Expression)

MySQL QUOTE Example

The string QUOTE function escapes the backslash and single quote in a given string, and returns the string surrounded by single quotations. The following query shows multiple ways to use this QUOTE function.

SELECT QUOTE('Don\'t Do it');

SELECT QUOTE('Tutorial''Gateway');

SELECT QUOTE('Tutorial \'Gateway');

OUTPUT

MySQL QUOTE Function 1

You can also use this QUOTE function on a column Data. This example shows you, how to use this function on Email column.

SELECT FirstName,
       LastName,
       DepartmentName,
       QUOTE(DepartmentName),
       Email,
       QUOTE(Email)
 FROM `MySQL Tutorial`.employe;

OUTPUT

MySQL QUOTE Function 2

Thank You for Visiting Our Blog