स्ट्रिंग में नंबर है या नहीं जांचने के लिए REGEXP यानी रेगुलर एक्सप्रेशन का उपयोग करें।
सिंटैक्स
SELECT * FROM yourTableName WHERE yourColumnName REGEXP '[0-9]';
उदाहरण के साथ समझें
सबसे पहले एक टेबल बनाते हैं:
mysql> CREATE TABLE StringContainsNumber (
-> Id INT NOT NULL AUTO_INCREMENT,
-> Words TEXT,
-> PRIMARY KEY(Id)
-> );
Query OK, 0 rows affected (0.53 sec)
रिकॉर्ड डालें
mysql> INSERT INTO StringContainsNumber(Words) VALUES('He12345llo');
Query OK, 1 row affected (0.19 sec)
mysql> INSERT INTO StringContainsNumber(Words) VALUES('MySQL is not a programming 4language');
Query OK, 1 row affected (0.17 sec)
mysql> INSERT INTO StringContainsNumber(Words) VALUES('Java is an object oriented');
Query OK, 1 row affected (0.18 sec)
mysql> INSERT INTO StringContainsNumber(Words) VALUES('Java does not support 456 multiple inheritance');
Query OK, 1 row affected (0.20 sec)
mysql> INSERT INTO StringContainsNumber(Words) VALUES('MySQL is a RDBMS 456');
Query OK, 1 row affected (0.19 sec)
सभी रिकॉर्ड देखें
mysql> SELECT * FROM StringContainsNumber;
आउटपुट
+----+------------------------------------------------+ | Id | Words | +----+------------------------------------------------+ | 1 | He12345llo | | 2 | MySQL is not a programming 4language | | 3 | Java is an object oriented | | 4 | Java does not support 456 multiple inheritance | | 5 | MySQL is a RDBMS 456 | +----+------------------------------------------------+ 5 rows in set (0.00 sec)
नंबर वाली स्ट्रिंग खोजने की क्वेरी
mysql> SELECT * FROM StringContainsNumber
-> WHERE Words REGEXP '[0-9]';
आउटपुट
+----+------------------------------------------------+ | Id | Words | +----+------------------------------------------------+ | 1 | He12345llo | | 2 | MySQL is not a programming 4language | | 4 | Java does not support 456 multiple inheritance | | 5 | MySQL is a RDBMS 456 | +----+------------------------------------------------+ 4 rows in set (0.11 sec)
रेगुलर एक्सप्रेशन [0-9] किसी भी अंक (0-9) से मेल खाता है।
