I have table with field called description which contains text like following
|Description |
|-----------------------------------------|
|This is a text <a>blah</a> <br/> <img /> |
|This is <b>second</b> <a>row</a> |
I would like to remove everything between "<" and ">"
Required Output
|Description |
|-----------------------------------------|
|This is a text blah |
|This is second row |
Is there anyway I can achieve this using MYSQL query. I cant currently use Stored procedure for the same as I don't have rights. I have requested for the access to use stored procedure but that will take some time and I have to finish this bit urgently.
Thanks.
Update: my question is similar to Remove string between 2 characters from text string but I want it to be done in MYSQL query.
Aucun commentaire:
Enregistrer un commentaire