repo.or.cz
/
maemopadplus.git
/
blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
history
|
raw
|
HEAD
informative file for searching and how we can implement it in sqlite
[maemopadplus.git]
/
search-maemopadplus.sql
blob
1164df78ae6a1375c452aa04158682345ce3cc5f
1
SELECT nodeid FROM checklists WHERE name LIKE ?
2
UNION
3
SELECT nodeid FROM nodes WHERE name LIKE ? OR (bodytype=1 AND bodyblob LIKE ?);
4