PHP's strip_tags() equivalent MYSQL function
Posted: Fri Jan 15, 2010 5:40 am
Hello forums!
I was just wondering to know how this can be accomplished:
Case:
Problem: Suppose my keyword=font & body field contains:
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:
or by any other means?
Thanks
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