Bug #1627 New Function: STRSPN(string1, string2)
Submitted: 22 Oct 2003 9:32 Modified: 3 Feb 2012 13:34
Reporter: Andreas Delleske Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:all OS:Any (all)
Assigned to:
Triage: Triaged: D5 (Feature request)

[22 Oct 2003 9:32] Andreas Delleske
Description:
In my opinion, there should be a function like

integer STRSPN(string1, string2)

(see same function name and meaning in PHP4!)

which counts the numbers of equal characters in string1 and string2, beginning with the first characters in each and sttopping by the first unequal character:

STRSPN("horsepower","horseshoe") = 5
STRSPN("foo", "bar") = 0 (an obligatory example! :-))
STRSPN("horsecat", "ho") = 2

...

The "moral justification" :-) of this feature request is that the number of adjacent characters is at hand anyway at every string comparison and needs no extra calculations!

(Well maybe the normal comparison algorithm compares 4 bytes at once... but there should be a solution...)

Without this function, things have to be made with much more hassle and subqueries and so on...

How to repeat:
its not a bug, its a feature (request :-)

Suggested fix:
soon :-))
[10 Dec 2005 17:27] Valerii Kravchuk
Thank you for a reasonable feature request.
[3 Feb 2012 13:34] Andreas Delleske
It is somewhat funny to see that a reasonable feature request of mine has been submitted in 2003, acknowledged as reasonable in 2005 but nothing happened since..