How to remove first paragraph of content in PHP?

Question

I have got field in database with <p>intro content</p><p>rest of content....</p>

How to remove first paragraph of content <p>intro content</p> using PHP?

Answer 1

assuming mysql

SELECT SUBSTRING_INDEX(content_field, '</p>', 1) as cut from TABLE

replace in db:

update [table_name] set [field_name] = replace([field_name],SUBSTRING_INDEX([field_name], '</p>', 1),'');

Answer 2

Use a DOM parser. Maybe PHPQuery. You can then select the first element from the DOM and remove it

Pseudo Code:

$dom->firstChild()->remove();