How does the MySQL QUOTE() function handle comparison values?

When using the WHERE clause with the QUOTE() function, the output depends on the comparison value returned by the WHERE clause. The following example will be shown:

Example

mysql> Select Name, ID, QUOTE(Subject)AS Subject from Student WHERE Subject = 'History';

+-------+------+-----------+
| Name  | ID   | Subject   |
+-------+------+-----------+
| Aarav | 2    | 'History' |
+-------+------+-----------+

1 row in set (0.00 sec)

The above is the detailed content of How does the MySQL QUOTE() function handle comparison values?. For more information, please follow other related articles on the PHP Chinese website!