Skip to content

Instantly share code, notes, and snippets.

@Semdevmaster

Semdevmaster/search value in set with ||

Created August 12, 2017 04:44
Show Gist options
  • Save Semdevmaster/5f1bbe3ac080614c3b7e9941800da62b to your computer and use it in GitHub Desktop.
Save Semdevmaster/5f1bbe3ac080614c3b7e9941800da62b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
search value in set with ||
[[pdoResources?
&parents=`3`
&includeTVs=`test`
&tvPrefix=``
&processTVs=`test`
&tpl=`@INLINE
<p>[[+pagetitle]]</p>
<sub>[[+test]]</sub>
`
&where=`["1 = 1 AND FIND_IN_SET('5', replace(test, '||', ','))"]`
]]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment