How does MySQL QUOTE() function work with comparison values?

MySQLMySQLi Database

<p style="">When QUOTE() function used with WHERE clause then the output depends upon the comparison values returned by WHERE clause. Following example will exhibit it &minus;</p><h2 style="">Example</h2><pre class="result notranslate">mysql&gt; Select Name, ID, QUOTE(Subject)AS Subject from Student WHERE Subject = &#39;History&#39;; +-------+------+-----------+ | Name &nbsp;| ID &nbsp; | Subject &nbsp; | +-------+------+-----------+ | Aarav | 2 &nbsp; &nbsp;| &#39;History&#39; | +-------+------+-----------+ 1 row in set (0.00 sec)</pre>
Updated on 20-Jun-2020 10:42:27