I was just wondering to know how this can be accomplished:
Case:
Code: Select all
SELECT * FROM cms_pages WHERE body LIKE '%keywords%';Code: Select all
<div style="font-size:12px">This is a body area</div>I would like to know,
is there any function to strip the html tags while executing query?
something like:
Code: Select all
SELECT * FROM cms_pages WHERE strip_tags(body) LIKE '%keywords%';Thanks