Today, We want to share with you SQL Remove Numeric Characters in String.In this post we will show you sql remove non numeric characters without function, hear for Remove Numeric Characters in String using SQL we will give you demo and example for implement.In this post, we will learn about Sql function remove numeric characters from column with an example.
SQL Remove Numeric Characters in String
There are the Following The simple About SQL Remove Numeric Characters in String Full Information With Example and source code.
As I will cover this Post with live Working example to develop sql remove characters from string, so the sql remove non numeric characters from a string for this example is following below.
Create deleteNum function:
DROP FUNCTION IF EXISTS deleteNum; DELIMITER | CREATE FUNCTION deleteNum( str CHAR(32) ) RETURNS CHAR(16) BEGIN DECLARE first_value, cnt SMALLINT DEFAULT 1; DECLARE myrt CHAR(32) DEFAULT ''; DECLARE c CHAR(1); SET cnt = CHAR_LENGTH( str ); REPEAT BEGIN SET c = MID( str, first_value, 1 ); IF c REGEXP '[[:alpha:]]' THEN SET myrt=CONCAT(myrt,c); END IF; SET first_value = first_value + 1; END; UNTIL first_value > cnt END REPEAT; RETURN myrt; END | DELIMITER ;
Use With MySQL Select Query:
SELECT deleteNum(products.name) FROM `products`
I hope you get an idea about SQL Remove Numeric Characters in String.
I would like to have feedback on my Pakainfo.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.