[Gllug] OT: SQL counting regex matches within a field

[Ian Norton]

Hi folks,

does anyone know how to cound the number of times a match occurs within a
field in mysql?

my only working method involves iterating through every field using perl and
counting the regex matches, i dont want to have to do that really :-/

Ian

-- 
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GCS dpu s--: a-- C++++ UL++ P+++ L+++ E--- W-- N+ o K w---
O M-- V-- PS++ PE-- Y+ PGP+ t+++ 5++ X++ R+++ !tv b DI D----
G++ e+ h++ r++ y+++
------END GEEK CODE BLOCK------
----- Message of the Hour ------
Moooo :-)

-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug