Bug #1207 substr_count

Submitted: 5 Sep 2003 17:02 Modified: 9 Sep 2011 7:40
Reporter: Sorin Neacsu Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[5 Sep 2003 17:02] Sorin Neacsu
Description:
I think a function similar to substr_count should be implemented. Since there is a function to 'multiply' strings (REPEAT), I really think there should be the opposite. Any tips ?

How to repeat:
I think a function similar to substr_count should be implemented. Since there is a function to 'multiply' strings (REPEAT), I really think there should be the opposite. Any tips ?
[26 Nov 2005 11:38] Valeriy Kravchuk
Thank you for a feature request.

Please, read the manual (http://dev.mysql.com/doc/refman/5.0/en/string-functions.html). I think, LOCATE function already implelemented allows to do what you asked for.
[12 Feb 2009 11:01] PANEL Martin
LOCATE() can not count string repetition and no other function can it.
[9 Sep 2011 7:34] Sergei Kulakov
I'd like to add my voice for the function. I too need a function to count the number of substring occurrences in a string, like PHP's substr_count(), it would really be handy. Right now we can achieve the same functionality by using the Replace() function:

Cast((Length(Str)-Length(Replace(Str, Substr, '')))/Length(Substr) as Unsigned)

But this is a bit cumbersome, as you can see. It would also be convenient to have a native implementation of substr_count() that would be case-insensitive (right now, of course, case insensitivity can also be achieved by using Lower() with Replace() but this will make the expression still more cumbersome).
[9 Sep 2011 7:40] Valeriy Kravchuk
OK, although different workarounds are possible, this feature can still be useful.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.