How to write a SQL query to remove unnecessary?

M

M252018-02-06 15:14:29

MySQL

M25, 2018-02-06 15:14:29

Schematic contents of cells

мусор_мусор_мусор <table> полезное содержание </table> мусор мусор мусор

how to remove everything outside the table tag?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

M

Max Payne, 2018-02-06
@YardalGedal

Regular expressions.

T

TheRonCronix, 2018-02-06
@TheRonCronix

The easiest way is to use a combination of instr/substr functions