select operation on medium text data

eduinfo

Hi,
this is a question related to querying a table in MYSql
.I have a table with two fields.
1. item_id which is an auto number
2. item_data which is a mediumText field.

The field Item_data stored contains html data.
That is there is some relevent data along with the data for formatting the useful data.

Now my problem is that i would like to do a keyword search in the item_data field.
My problem is that if i use the normal select query like

select * from table where item_data LIKE "%keyword%"

results are returned even if the data inside the html tage contains the necessary keywords.

I want to search only the data and not the html.

Is there any way by which this can be accomplished.
will be very greatful for a reply.
Thanks/Regards
Sanket Gupta

kinglouie

Have a look at the regexp-operators MySQL provides. They could be useful on this issue.
Best regards,

King Louie

eduinfo

Hi,
i am not very good at regular expressions.

i understand that i need to use something like

REGEXP '$term' in the where clause.

the term is the keyword to be searched.
Can you give me the regular expression for doing this so that only the data inside the html is searched.

I will be greatful.
Thanks/Regards
Sanket gupta