How to replace data in a table?

I

iddddy2019-10-07 20:52:26

SQL

iddddy, 2019-10-07 20:52:26

There is a video table, it has a channel column, which can look like 0|10|0 or 0|10|17|0 or 0|10|17|15|0.
How to replace data, you need to leave the first value after 0|, delete the rest, that is, in this example, only 10 should remain.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

D

Dmitry, 2019-10-07
@Compolomus

update video set channel = TRIM(BOTH '0|' FROM SUBSTRING_INDEX(`channel`, '|', 2))

It seems to work

Similar questions

N

NyxDeveloper2021-05-04 16:15:55

How to forbid assigning id to fields of ForignKey of that object, whose certain field is equal to False? 4Reply

D

devKazhan2019-11-13 19:12:32

Missing unique pages from the index in favor of someone who steals them? 4Reply

V

Vladislav Balabanovich2015-08-31 14:45:00

How to create ajax cart widget in woocommerce? 3Reply

V

Vlad2017-09-30 00:57:53

How to scroll through all the news in Opencart? 2Reply

A

ashflame2015-01-30 10:36:10

Export data from MS SQL to international geophysical data format (LAS)? 0Reply

Didn't find what you were looking for?

Ask your question