F
F
Froggyweb2019-07-03 14:43:05
MySQL
Froggyweb, 2019-07-03 14:43:05

How to remove leading slash from sample result?

There is a selection of the necessary rows from the table

SELECT *  FROM `modx_site_tmplvar_contentvalues` WHERE `tmplvarid` = 4

how to remove / if it is at the beginning of the line in the selected rows in the value cell

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Melkij, 2019-07-03
@Froggyweb

trim(leading '/' from value)
?
https://dev.mysql.com/doc/refman/8.0/en/string-fun...

T
TheRonCronix, 2019-07-03
@TheRonCronix

function substr

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question