Hi!
Well.. I have site content for pages in a MS databse.
I added a search page that queries this content using LIKE to find pages that have that content.
The problem and challege is... the SQL DB holds the HTML info and when you search it .. you are likely to find results for pages that have you keyword in the tags.
How do I do a regular expression against SQL to look up keywords outside of certain (most) tags.
Any ideas?
I know about this code:
But that is not for a SQL query...
Can it even be done?
Well.. I have site content for pages in a MS databse.
I added a search page that queries this content using LIKE to find pages that have that content.
The problem and challege is... the SQL DB holds the HTML info and when you search it .. you are likely to find results for pages that have you keyword in the tags.
How do I do a regular expression against SQL to look up keywords outside of certain (most) tags.
Any ideas?
I know about this code:
But that is not for a SQL query...
Can it even be done?