From http://blog.csdn.net/zhjp4295216/article/details/5776954
Select path | '%' from t_category where depth = 0 and type = 0
Concatenate a string with '|'
For example, if path is/1001/, the result is/1001/%.
Number Addition
select 'A' + 'B' the result is 0
select " A "+" 1 " the result is 1
select " A "+ 1 the result is 1
Select2 + 1Result 3
= In the "+" operation, SQLite treats non-numeric strings of 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
<= Relational less than or equal
> Relational greater
> = Relational greater than or equal
= Relational equal
= Relational equal
<> Relational not equal
! = Relational not equal
In Logical in
And Logical and
Or Logical or
Like Relational String Matching
Glob Relational filename matching