Skip to content

Instantly share code, notes, and snippets.

@devacto

devacto/sub_string_count.sql

Created November 6, 2013 03:41
Download ZIP

Revisions

  1. devacto created this gist Nov 6, 2013.
    2 changes: 2 additions & 0 deletions sub_string_count.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,2 @@
    CREATE FUNCTION substrCount(x varchar(255), delim varchar(12)) returns int
    return (length(x)-length(REPLACE(x, delim, '')))/length(delim);