LIKE AND ignore HTML Tags

[bdichiara]

Is it possible when using in a query:

"WHERE fieldname LIKE '%$mysearch%'"

to ignore HTML Tags in the database. For example:

$mysearch = "h1";
"WHERE content LIKE '%$mysearch%'"

Also, is LIKE case sensitive? So searching for:
search: Jones
returns: jones & Jones & JoNeS

or does it only return: Jones

Thanks.


_______________

 

[r937]

LIKE is case-insensitive

to avoid search results including html tags, you might want to consider storing a plain-text as well as an hmtl version of the content -- search the plain text version, and return the html version

searching just the html version is going to kill you if you don't want to return results for things like class names, comments, etc.

r937.com | rudy.ca

 

[bdichiara]

Good suggestion, I'll have that a try. Thanks.

_______________
_brian.