PHP's strip_tags() equivalent MYSQL function

[PHPycho]

Hello forums!
I was just wondering to know how this can be accomplished:
Case:

SELECT * FROM cms_pages WHERE body LIKE '%keywords%';

Problem: Suppose my keyword=font & body field contains:

<div style="font-size:12px">This is a body area</div>

then above query fetches this row.

I would like to know,
is there any function to strip the html tags while executing query?
something like:

SELECT * FROM cms_pages WHERE strip_tags(body) LIKE '%keywords%';

or by any other means?

Thanks

[halojoy]

Maybe you wouldnt need to strip tags
if you use LIKE %word%
% = Any characters
Could be < or >

SELECT * FROM cms_pages WHERE body LIKE '%keywords%';

You can however CREATE FUNCTION in mysql.
A userdefined strip_tags function, for example.

[johanafm]

But you do not want to perform that kind of operation every time a user performs a search. Do the job once, not every time. And you do not want <body="font-size:10">This text does not contain f o n t anywhere...</body> to match either.

Just store the text both with and without markup. With markup for presentation purposes, without markup for searching.