- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How does MySQL QUOTE() function work with comparison values?
When QUOTE() function used with WHERE clause then the output depends upon the comparison values returned by WHERE clause. Following example will exhibit it −
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)
- Related Articles
- How does comparison operator work with date values in MySQL?
- How does MySQL IF() function work?
- How does tuple comparison work in Python?
- How to quote values using MySQL group_concat?
- In MySQL, how IN() comparison function works?
- How does MySQL CASE work?
- How to quote values of single column using GROUP_CONCAT and CONCAT with DISTINCT in MySQL?
- How does issubclass() function work in Python?
- How does isinstance() function work in Python?
- How does recursion function work in JavaScript?
- How can I update MySQL table after quoting the values of a column with a single quote?
- How does the bin2hex() function work in PHP?
- What MySQL returns if the argument of QUOTE() function is NULL?
- How can I get the output based on comparison done with column’s name using MySQL IN() function?
- In MySQL, how does the precedence of ! operator in comparison with NOT operator depends upon HIGH_NOT_PRECEDENCE SQL mode?

Advertisements