Hi

I have a table with the following structure

Post longtext
title varchar(200)

and other columns…

In the post column I have text which is HTML format.

Now I want to grab the title of each post which is present inside the <title> …</title>tag and insert it into the title column.

I have been trying lot of string functions but couldn’t accomplish it. Can any offer me some suggestion?

RegExp returns 0 or 1 - there doesnt seem to be any option to return the matches.

So you'll have to actually do this using some scripting language.

Hi Anjanesh,

Thanks for the reply.

Even I was thinking that this will not be possible using MySQL alone and thanks for confirming it. I will try to do it using PHP.