QUOTE() FUNCTION in MySQL

QUOTE() FUNCTION The MySQL QUOTE function is used to get the string that is passed in a single quote.

Syntax:

QUOTE (string);

Parameters: string: It is used to specify the string to evaluate.

Example:

mysql> SELECT QUOTE (‘ABC’);

Output:

‘ABC’

Explanation: The string within the single quote is returned.

Please follow and like us:
Content Protection by DMCA.com