- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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?
<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 −</p><h2 style="">Example</h2><pre class="result notranslate">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)</pre>
Updated on 20-Jun-2020 10:42:27
- Related Questions & Answers
- 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?
- How does MySQL CASE work?
- How does recursion function work in JavaScript?
- How does issubclass() function work in Python?
- How does isinstance() function work in Python?
- In MySQL, how IN() comparison function works?
- How does the bin2hex() function work in PHP?
- How to quote values of single column using GROUP_CONCAT and CONCAT with DISTINCT in MySQL?
- How does jQuery.scrollTop() work?
- How does jQuery.scrollLeft() work?
- How does classification work?
- How does backpropagation work?
Advertisements