
- 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
Set numbers as a varchar field and compare in MySQL
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
+-----------+--------------+ | 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
+-----------+--------------+ | StudentId | StudentScore | +-----------+--------------+ | 2 | 100 | | 4 | 98 | +-----------+--------------+ 2 rows in set (0.00 sec)
- Related Questions & Answers
- Can we compare numbers in a MySQL varchar field?
- How to set a string with hyphen and numbers in MySQL varchar?
- Delete last value and fix two new values (VARCHAR Numbers) in MySQL declared as VARCHAR?
- How to display highest value from a string with numbers set as varchar in MySQL?
- Convert from varchar to datetime and compare in MySQL?
- Sorting varchar field numerically in MySQL?
- Order VARCHAR records with string and numbers in MySQL
- Getting the maximum value from a varchar field in MySQL
- Searching for an integer value in a varchar field in MySQL?
- Searching BETWEEN dates stored as varchar in MySQL?
- Compare only day and month with date 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 by date set with varchar type in MySQL
- Use of String.compare for a varchar field in SAP
Advertisements