SUBSTRING_COUNT() FOR MySQL
Januar 13th, 2009 by Blu:RayNe
Just as needed…
DROP FUNCTION IF EXISTS SUBSTRING_COUNT;
CREATE FUNCTION SUBSTRING_COUNT (haystack TEXT, needle VARCHAR(255)) RETURNS INT DETERMINISTIC
BEGIN
RETURN LENGTH(haystack) – LENGTH(REPLACE(haystack, needle, ""));
END
CREATE FUNCTION SUBSTRING_COUNT (haystack TEXT, needle VARCHAR(255)) RETURNS INT DETERMINISTIC
BEGIN
RETURN LENGTH(haystack) – LENGTH(REPLACE(haystack, needle, ""));
END
Filed under Allgemein having 1 Comment »
September 6th, 2009 at 20:32
its not 100% correct. here’s a better one:
…
RETURN (LENGTH(haystack) – LENGTH(REPLACE(haystack, needle, “”)))/LENGTH(needle);
…