A
A
Anton @ Lyalin2017-03-31 11:15:06
Java
Anton @ Lyalin, 2017-03-31 11:15:06

How to replace some characters in sqlite?

there is a database in sqlite, and there is a column with text that has a '\n' character in it that needs to be removed.
How to do it?
Team

update 'table' set 'name' = replace(name, '\n', '_')
does not work.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton @ Lyalin, 2017-04-01
@toxa_1995

Issue resolved, this command works

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question