var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Parse text inside a longtext column
I have a table with the following structure
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.
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.