[thelist] How to crosssearch texts and keywords?

[Manuel González Noriega]

Hi, I've got (mysql) quite a high number of mid-sized (1-m) texts and
a long lists of keywords (1-n). I need to locate every appearance of
each keyword on each text. Should I approach this with only php +
common sense or is there any well know methodology / algorithm / etc.
that applies to this situation?

Thanks in advance
-- 
Manuel 
a veces :) a veces :( 
pero siempre trabajando duro para Simplelógica: apariencia,
experiencia y comunicación en la web.
http://simplelogica.net # (+34) 985 22 12 65
        
¡Ah! y escribiendo en Logicola: http://simplelogica.net/logicola/