

- 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
Can we compare numbers in a MySQL varchar field?
Yes, we can do this by first using CAST(). Let us first create a table −
mysql> create table DemoTable -> ( -> StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> StudentScore varchar(100) -> ); Query OK, 0 rows affected (0.66 sec)
Insert some records in the table using insert command −
mysql> insert into DemoTable(StudentScore) values('90'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable(StudentScore) values('100'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable(StudentScore) values('56'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable(StudentScore) values('98'); Query OK, 1 row affected (0.13 sec)
Display all records from the table using select statement −
mysql> select *from DemoTable;
Output
This will produce the following output −
+-----------+--------------+ | StudentId | StudentScore | +-----------+--------------+ | 1 | 90 | | 2 | 100 | | 3 | 56 | | 4 | 98 | +-----------+--------------+ 4 rows in set (0.00 sec)
Here is the query to compare in varchar fields −
mysql> select *from DemoTable where CAST(StudentScore AS SIGNED) > 91;
Output
This will produce the following output −
+-----------+--------------+ | StudentId | StudentScore | +-----------+--------------+ | 2 | 100 | | 4 | 98 | +-----------+--------------+ 2 rows in set (0.00 sec)
- Related Questions & Answers
- Set numbers as a varchar field and compare in MySQL
- Sorting varchar field numerically in MySQL?
- How can we compare data in two MySQL tables?
- Getting the maximum value from a varchar field in MySQL
- Convert from varchar to datetime and compare in MySQL?
- Searching for an integer value in a varchar field in MySQL?
- MySQL query to remove numbers after hyphen in a VARCHAR string with numbers
- Count the number of occurrences of a string in a VARCHAR field in MySQL?
- Order VARCHAR records with string and numbers in MySQL
- Can we add minutes to VARCHAR datetime records while applying INSERT statement in MySQL?
- Can we select field name in MySQL that contains an asterisk?
- How can we compare a StringBuilder with StringBuffer in Java?
- Use of String.compare for a varchar field in SAP
- Delete last value and fix two new values (VARCHAR Numbers) in MySQL declared as VARCHAR?
- How to set a string with hyphen and numbers in MySQL varchar?
Advertisements