MySQL - Consulta para contar palabras en registros tabla

SELECT LENGTH(REPLACE(TEXTO, 'noche', '')) AS `repeticiones` FROM poema

select sum(`repeticiones`) from

(SELECT LENGTH(REPLACE(TEXTO, 'noche', '')) AS `repeticiones` FROM poema) as s

SELECT LENGTH(REPLACE(TEXTO, 'noche', '')) AS `repeticiones` FROM poema

create table prueba

(titulo VARCHAR(100), texto VARCHAR(100));

INSERT INTO prueba values

('test1', 'Una noche, llena de estrellas,'),

('test2','noche estrellada, noche sin luna,' ),

( 'test3','noche perdida en la nada,'),

( 'test4','noche helada, noche cansada.'),

( 'test5','sin la palabra buscada');

select titulo

     , texto

     , length(texto) as largo_cadena

     , length(replace(texto,'noche','')) as largo_cadena_sin_palabra

     , (length(texto)-length(replace(texto,'noche','')))/length('noche')

       as veces

from   prueba

select SUM(veces) as Total_Veces

from   (select titulo

             , texto

             , length(texto) as largo_cadena

             , length(replace(texto,'noche','')) as largo_cadena_sin_palabra

             , (length(texto)-length(replace(texto,'noche','')))/length('noche')

               as veces

        from   prueba) q1

;