SQLite string concatenation

Select Path | | '% ' from t_category where depth = 0 and type = 0

Use ' | | ' Stitching strings

For example, if path is/1001/, the result is/1001/%.

Add numbers

SELECT ' A ' + ' B ' result is 0

Select "A" + "1" result is 1

Select "A" +1 result is 1

SELECT 2+1 result is 3

= in the "+" operation, SQLite treats string non-numeric strings as 0.

||String concatenation
*Arithmetic Multiply
/Arithmetic Divide
%Arithmetic modulus
+Arithmetic ADD
–Arithmetic Subtract
<<Bitwise Right Shift
>>Bitwise left Shift
&Logical and
|logical Or
< relational less than
<=  relational less than or equal to
>  Relational Greater than
>= relational Greater than or equal to
= < Span class= "Apple-tab-span" >relational Equal to
== relational Equal to
< > relational not equal to
!= Relational Not equal to
In logical in
And Logical and
Or logical OR
Like Relational String matching
Glob relational Filename matching

SQLite string concatenation