Re: Mysql search html tags excluded
| From: | Ashley Sheridan | Date: | Fri, 04 Jun 2010 11:36:11 +0000 |
| Subject: | Re: Mysql search html tags excluded | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-305806@lists.php.net to get a copy of this message | ||
On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote:
> Hello,
>
> if there is some webpage content with html tags in database is it possible
> to search it without tags?
>
> data : '<div style="">you need some styling!</div>'
>
> when i now search for 'you style' i don't want to get any rows! is it
> possible?
> when i search 'you styling' i get the row!
>
> Br
> Tanel
>
>
>
Use a second field in the DB that stores the content without any HTML
tags. That way, you can search and not worry about tags and attribute
values getting in the way.
Thanks,
Ash
http://www.ashleysheridan.co.uk