Skip to content

Instantly share code, notes, and snippets.

View pateltejasmca's full-sized avatar

Tejas Patel pateltejasmca

0 followers · 5 following
  • A One Salasar
  • Mumbai
View GitHub Profile
@pateltejasmca
pateltejasmca / gist:32456eafe85f14c56af378d282b70b9a
Created October 3, 2018 11:16 — forked from slav123/gist:4274088
Extract Number From String MySQL
select uExtractNumberFromString(mobile) from customer_masterCREATE FUNCTION `uExtractNumberFromString`(in_string varchar(50)) RETURNS INT
NO SQL
BEGIN
DECLARE ctrNumber varchar(50);
DECLARE finNumber varchar(50) default ' ';
DECLARE sChar varchar(2);