Re: SQLite and SELECT WHERE local_relpath LIKE

[Peter Samuelson]

[Philip Martin]
>   sqlite3 wcx.db "select count(*) from nodes where wc_id = 1 and 
> local_relpath = 'zag1/zag27'"
> 
>   sqlite3 wcx.db "select count(*) from nodes where wc_id = 1 and 
> (local_relpath > 'zig1/zag27/' and local_relpath < 'zig1/zag270')"

>   sqlite3 wcx.db "select count(*) from nodes where wc_id = 1 and 
> local_relpath = 'zig1/zag27' or (local_
relpath > 'zig1/zag27/' and local_relpath < 'zig1/zag270')"

AND has higher precedence than OR, so you want more parens:

    sqlite3 wcx.db "select count(*) from nodes where wc_id = 1 and 
(local_relpath = 'zig1/zag27' or (local_relpath > 'zig1/zag27/' and 
local_relpath < 'zig1/zag270'))"

Peter