Thank you to anyone who has already donated - your generous donations helped make three months of treatment possible.

My brother Nate continues to fight stage IV Hodgkin's lymphoma. He's just 31, with a wife and baby girl. They have no active income (since he's been unable to return to work), no insurance, and cannot afford the treatment he needs. Nate and his family need your help. Please consider a donation, every dollar helps. Thanks.

Read Nate's story Support Nate by buying an official Pastie t-shirt Hide this message

Document@2x
|
Chain_link@2x
|
Arrow_down@2x
|
Spiral_paper@2x
A A A

SQL       Report abuse 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

DELIMITER //
CREATE FUNCTION ltrim_junk_mysql(str VARCHAR(70))
RETURNS VARCHAR(70)
BEGIN

DECLARE len INT;
DECLARE pos INT;

-- Quickly return if first character is alphanumeric
IF SUBSTRING(str, 1, 1) REGEXP '[[:alpha:]]' THEN
  RETURN str;
END IF;

SET len = LENGTH(str);
SET pos = 1;

WHILE pos <= len DO
  IF SUBSTRING(str, pos, 1) REGEXP '[[:alpha:]]' THEN
   RETURN SUBSTRING(str, pos);
  END IF;
  SET pos = pos + 1;
END WHILE;

RETURN '';
END;

//

DELIMITER ;