Great.
A note - since 'yes' is a constant, it would be better to change
to make mysql use exact value search vs partial word search (10x slower).
If you put in custom_field in cms:pages 'book_collection_belong==yes', you will see the difference in returned sql, which will prove my above point. This exact match is revealed here http://docs.couchcms.com/tags-reference ... stom_field
A note - since 'yes' is a constant, it would be better to change
- Code: Select all
t1.search_value LIKE '%yes%'
to make mysql use exact value search vs partial word search (10x slower).
- Code: Select all
t1.search_value = 'yes'
If you put in custom_field in cms:pages 'book_collection_belong==yes', you will see the difference in returned sql, which will prove my above point. This exact match is revealed here http://docs.couchcms.com/tags-reference ... stom_field