字符串连接在SQLite中不起作用 [英] String concatenation does not work in SQLite

问题描述

我正在尝试执行SQlite替换功能，但是在该功能中使用了另一个字段.

I am trying to execute a SQlite replace function, but use another field in the function.

select  locationname + '<p>' from location;

在此片段中，结果为0列表.我本来希望有一个字符串，其中包含来自locationname和'<p>'文字的文本.

In this snip, the result is a list of 0s. I would have expected a string with the text from locationname and the '<p>' literals.

推荐答案

尝试使用||代替+

select  locationname || '<p>' from location;

来自 SQLite文档 :

||运算符是串联的"-它将其操作数的两个字符串连接在一起.

The || operator is "concatenate" - it joins together the two strings of its operands.

这篇关于字符串连接在SQLite中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！