Replace html tags with query

[mirocafal]

Hi,
I’m trying my first work with base. I have connection to mysql database and working query. But in table one collum has html tags. Response look like this:

It is possible to make query, where I will be able filter theese tags for show in query result? I don’t want delete it in table.

Thank you.

[RobertG]

All this “tags” have same length?
Leading tag with 9 characters, ending tag with 10 characters.

SELECT `id`, `name`, `date`,  
SUBSTRING(`content`,10,CHAR_LENGTH(`content`)-10) AS `content` 
FROM `table`

Hope this will work. Could also try it with REPLACE:

SELECT `id`, `name`, `date`,  
REPLACE(REPLACE(`content`,'<p>',''),'</p>','') AS `content` 
FROM `table`

[mirocafal]

Thank you it works great.