%3CLINGO-SUB%20id%3D%22lingo-sub-212233%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%A6%82%E4%BD%95%E5%9C%A8%20SQL%20%E6%9F%A5%E8%AF%A2%E4%B8%AD%E7%BC%96%E5%86%99%E5%A4%9A%E4%B8%AA%E2%80%9CContains%E2%80%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-212233%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CDIV%20class%3D%22forum-topic-flex-article%22%3E%3CDIV%20class%3D%22forum-article%22%3E%3CDIV%20class%3D%22forum-post%22%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%E5%A4%A7%E5%AE%B6%E5%A5%BD%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E5%81%87%E8%AE%BE%E6%88%91%E6%9C%89%E4%B8%80%E4%B8%AA%E5%8C%85%E5%90%AB%E5%AD%97%E7%AC%A6%E4%B8%B2%E7%9A%84%E6%95%B0%E7%BB%84%EF%BC%8C%E8%BF%99%E4%BA%9B%E5%AD%97%E7%AC%A6%E4%B8%B2%E6%98%AF%E6%88%91%E9%9C%80%E8%A6%81%E4%BB%8E%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E6%8F%90%E5%8F%96%E7%9A%84%E8%A1%8C%E7%9A%84%E5%80%BC%E3%80%82%20%E5%81%87%E8%AE%BE%E6%95%B0%E7%BB%84%E6%98%AF%EF%BC%9A%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EsearchStringArray%20%3D%20%7B'qwe'%2C%20'rty'%2C%20'asd'%2C'%20fgh'%2C%20'zxc'%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E6%88%91%E5%8F%AF%E4%BB%A5%E7%94%A8%E4%B8%80%E7%A7%8D%E9%9D%9E%E5%B8%B8%E7%AE%80%E5%8D%95%E7%9A%84%E6%96%B9%E5%BC%8F%E5%9C%A8%E6%9F%A5%E8%AF%A2%E4%B8%AD%E6%9E%84%E5%BB%BA%20WHERE%20%E8%AF%AD%E5%8F%A5%EF%BC%9A%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%22WHERE%20%0At1.column1%20IN%20('%20%22%20%7C%7C%20Concat%20Items(searchStringsArray%2C%20%22%20'%2C%20'%20%22)%7C%7C%20%22%20'%20)%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E8%A7%A3%E6%9E%90%E6%97%B6%E4%BC%9A%E7%BB%99%E6%88%91%E4%BB%A5%E4%B8%8B%E5%AD%97%E7%AC%A6%E4%B8%B2%EF%BC%9A%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%22WHERE%0At1.column1%20IN('qwe'%2C%20'rty'%2C%20'asd'%2C%20'fgh'%2C%20'zxc')%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E4%BD%86%E6%98%AF%E5%A6%82%E6%9E%9C%E6%88%91%E7%9A%84%20searchStringArray%20%E4%B8%8D%E6%98%AF%E5%AE%8C%E6%95%B4%E5%AD%97%E7%AC%A6%E4%B8%B2%E8%80%8C%E6%98%AF%E9%83%A8%E5%88%86%E5%AD%97%E7%AC%A6%E4%B8%B2%E6%80%8E%E4%B9%88%E5%8A%9E%EF%BC%9F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E6%88%91%E9%9C%80%E8%A6%81%E7%AE%80%E5%8C%96%E6%88%91%E7%9A%84%E8%84%9A%E6%9C%AC%E3%80%82%20%E7%9B%AE%E5%89%8D%E6%88%91%E6%9C%89%E4%B8%80%E4%B8%AA%E5%8C%85%E5%90%AB%E5%A4%9A%E4%B8%AA%20Contains%20%E8%AF%AD%E5%8F%A5%E7%9A%84%E6%9F%A5%E8%AF%A2%EF%BC%8C%E5%9C%A8%20SQL%20%E4%B8%AD%E5%A6%82%E4%B8%8B%E6%89%80%E7%A4%BA%EF%BC%9A%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%22WHERE%3CBR%20%2F%3E(t1.column1%20LIKE%20'%25qwe%25')%20OR%0A(t1.column1%20LIKE%20'%25rty%25')%20OR%0A(t1.column1%20LIKE%20'%25asd%25')%20OR%0A(t1.column1%20LIKE%20'%25fgh%25')%20OR%0A(t1.column1%20LIKE%20'%25zxc%25')%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E4%BB%8E%E5%AD%97%E7%AC%A6%E4%B8%B2%E6%95%B0%E7%BB%84%E6%9E%84%E9%80%A0%E8%B5%B7%E6%9D%A5%E9%9D%9E%E5%B8%B8%E9%BA%BB%E7%83%A6%E3%80%82%20%E6%88%91%E6%83%B3%E7%9F%A5%E9%81%93%E6%98%AF%E5%90%A6%E5%8F%AF%E4%BB%A5%E7%BC%96%E5%86%99%E4%B8%80%E4%B8%AA%E7%AD%89%E6%95%88%E7%9A%84%20WHERE%20%E8%AF%AD%E5%8F%A5%EF%BC%8C%E5%A6%82%E4%B8%8B%E6%89%80%E7%A4%BA%EF%BC%9A%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%22WHERE%0At1.column1%20IN%20('%25qwe%25'%2C%20'%25rty%25'%2C%20'%25asd%25'%2C%20'%25fgh%25'%2C%20'%25zxc%25')%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E6%88%96%E7%B1%BB%E4%BC%BC%E7%9A%84%E4%B8%9C%E8%A5%BF%EF%BC%9A%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%22WHERE%0At1.column1%20MATCH('%25qwe%25'%20OR%20'%25rty%25'%20OR%20'%25asd%25'%20OR%20'%25fgh%25'%20OR%20'%25zxc%25')%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E6%88%96%E8%80%85%E7%B1%BB%E4%BC%BC%E7%9A%84%E4%B8%9C%E8%A5%BF%EF%BC%8C%E4%BD%BF%E7%94%A8%E5%AE%83%E6%9B%B4%E5%AE%B9%E6%98%93%E6%9E%84%E5%BB%BA%3CCODE%20class%3D%22%20language-jsl%22%3E%E8%BF%9E%E6%8E%A5%E9%A1%B9%E7%9B%AE()%3C%2FCODE%3E%20%E3%80%82%20%E6%88%91%E5%B0%9D%E8%AF%95%E4%BA%86%E4%B8%8A%E9%9D%A2%E7%9A%84%E4%B8%A4%E4%B8%AA%E4%BE%8B%E5%AD%90%EF%BC%8C%E8%99%BD%E7%84%B6%E5%AE%83%E4%BB%AC%E4%BC%BC%E4%B9%8E%E6%98%AF%E6%9C%89%E6%95%88%E7%9A%84%20SQLite%20%E8%AF%AD%E6%B3%95%EF%BC%8C%E4%BD%86%E5%AE%83%E4%BB%AC%E5%9C%A8%20JSL%20%E4%B8%AD%E4%B8%8D%E8%B5%B7%E4%BD%9C%E7%94%A8%E3%80%82%20%E6%9C%89%E4%BB%80%E4%B9%88%E5%BB%BA%E8%AE%AE%E4%B9%88%EF%BC%9F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E8%B0%A2%E8%B0%A2%EF%BC%8C%3C%2FP%3E%3CP%3E%E4%B8%AD%E5%8F%B7%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22KudosButton%20lia-button-image-kudos-wrapper%20lia-component-kudos-widget-button-version-3%20lia-component-kudos-widget-button-horizontal%20lia-component-kudos-widget-button%20lia-component-kudos-action%20lia-component-message-view-widget-kudos-action%22%3E%3CDIV%20class%3D%22lia-button-image-kudos%20lia-button-image-kudos-horizontal%20lia-button-image-kudos-disabled%20lia-button-image-kudos-not-kudoed%20lia-button%22%3E%3CDIV%20class%3D%22lia-button-image-kudos-give%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-212351%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%A6%82%E4%BD%95%E5%9C%A8%20SQL%20%E6%9F%A5%E8%AF%A2%E4%B8%AD%E7%BC%96%E5%86%99%E5%A4%9A%E4%B8%AA%E2%80%9CContains%E2%80%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-212351%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E7%9C%8B%E8%B5%B7%E6%9D%A5%E5%AE%83%E6%AD%A3%E5%9C%A8%E6%8C%89%E6%89%BF%E8%AF%BA%E5%B7%A5%E4%BD%9C%E3%80%82%20%E5%AE%83%E4%BA%A7%E7%94%9F%E7%9A%84%E7%BB%93%E6%9E%9C%E4%B8%8E%E6%88%91%E5%BD%93%E5%89%8D%E7%9A%84%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88%E7%BB%93%E6%9E%9C%E7%9B%B8%E5%90%8C%E3%80%82%3C%2FP%3E%3CP%3E%E6%88%91%E5%9C%A8%20JSL%20%E4%B8%AD%E4%BD%BF%E7%94%A8%E5%AE%83%EF%BC%8C%E7%94%A8%E4%B8%80%E4%BA%9B%E6%96%87%E6%9C%AC%E5%92%8C%E5%8F%98%E9%87%8F%E7%BB%84%E8%A3%85%E6%9F%A5%E8%AF%A2%E5%AD%97%E7%AC%A6%E4%B8%B2%E3%80%82%20%E4%BE%8B%E5%A6%82%EF%BC%8Ct1.column1%20%E4%B9%9F%E6%98%AF%E4%B8%80%E4%B8%AA%E5%8F%98%E9%87%8F%EF%BC%8C%E8%80%8C%E6%88%91%E4%BB%85%E5%AF%B9%20t1.column1%20%E7%9A%84%E5%85%B6%E4%B8%AD%E4%B8%80%E4%B8%AA%E5%8F%98%E9%87%8F%E8%BF%9B%E8%A1%8C%E9%83%A8%E5%88%86%E5%8C%B9%E9%85%8D%EF%BC%8C%E5%9B%A0%E6%AD%A4%E6%88%91%E5%BF%85%E9%A1%BB%E5%AF%B9%E4%B8%80%E4%B8%AA%E5%8F%98%E9%87%8F%E4%BD%BF%E7%94%A8%E7%B1%BB%E4%BC%BC%E7%9A%84%E5%86%85%E5%AE%B9%EF%BC%9A%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%22WHERE(t1.column1%20LIKE%20'%25qwe%25')%20OR%0A(t1.column1%20LIKE%20'%25rty%25')%20OR%0A(t1.column1%20LIKE%20'%25asd%25')%20OR%0A(t1.column1%20LIKE%20'%25fgh%25')%20OR%0A(t1.column1%20LIKE%20'%25zxc%25')%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CBR%20%2F%3E%E4%BD%BF%E5%BE%97%E7%BB%84%E8%A3%85%E7%B1%BB%E4%BC%BC%E7%9A%84%E4%B8%9C%E8%A5%BF%E5%8F%98%E5%BE%97%E9%9D%9E%E5%B8%B8%E5%A4%8D%E6%9D%82%3CCODE%20class%3D%22%20language-jsl%22%3E%E5%AD%97%E7%AC%A6%E4%B8%B2%E5%88%97%E5%90%8D%E7%A7%B0%20%3D%20%22%E5%88%97%201%22%3C%2FCODE%3E%E5%92%8C%3CCODE%20class%3D%22%20language-jsl%22%3EsearchStringArray%20%3D%20%7B'qwe'%2C%20'rty'%2C%20'asd'%2C%20'fgh'%2C%20'zxc'%7D%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E8%80%8C%E5%AF%B9%E4%BA%8E%E5%85%B6%E4%BB%96%E5%88%97%E5%8F%98%E9%87%8F%EF%BC%8C%E5%AE%83%E7%9A%84%E5%BD%A2%E5%BC%8F%E8%A6%81%E7%AE%80%E5%8D%95%E5%BE%97%E5%A4%9A%EF%BC%9A%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%22WHERE%20%0At1.%22%7C%7CstringColumnName%7C%7C%22%20IN%20('%20%22%7C%7CConcat%20Items(searchStringsArray%2C%22%20'%2C%20'%20%22)%7C%7C%22%20'%20)%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E7%8E%B0%E5%9C%A8%EF%BC%8C%E6%84%9F%E8%B0%A2%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8242%22%20target%3D%22_blank%22%3E%40WhiteMenCanJMP%3C%2FA%3E%E4%BB%96%E7%9A%84%E7%B1%BB%E4%BC%BC%E4%BA%8E%E7%BB%84%E8%A3%85%E5%8A%A8%E6%80%81%E6%9F%A5%E8%AF%A2%E5%AD%97%E7%AC%A6%E4%B8%B2%E7%9A%84%E4%BB%BB%E5%8A%A1%E5%B0%86%E4%BC%9A%E7%AE%80%E5%8D%95%E5%BE%97%E5%A4%9A%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E4%B8%8D%E7%94%A8%E6%8B%85%E5%BF%83%E8%87%AA%E5%AE%9A%E4%B9%89%E7%AA%97%E5%8F%A3%20-%20%E6%88%91%E6%97%A0%E8%AE%BA%E5%A6%82%E4%BD%95%E9%83%BD%E4%BC%9A%E7%94%A8%20JSL%20%E7%BC%96%E5%86%99%E8%84%9A%E6%9C%AC%E3%80%82%20%E5%B0%BD%E7%AE%A1%E6%9F%A5%E8%AF%A2%E7%94%9F%E6%88%90%E5%99%A8%E4%B8%AD%E7%9A%84%E8%87%AA%E5%AE%9A%E4%B9%89%E8%BF%87%E6%BB%A4%E5%99%A8%E6%97%A0%E8%AE%BA%E5%A6%82%E4%BD%95%E9%83%BD%E6%98%AF%E6%A3%80%E6%9F%A5%E8%AF%AD%E6%B3%95%E7%9A%84%E6%9C%80%E5%BF%AB%E6%96%B9%E6%B3%95%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-212338%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%A6%82%E4%BD%95%E5%9C%A8%20SQL%20%E6%9F%A5%E8%AF%A2%E4%B8%AD%E7%BC%96%E5%86%99%E5%A4%9A%E4%B8%AA%E2%80%9CContains%E2%80%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-212338%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E9%97%AE%E9%A2%98%E7%9A%84%E7%AC%AC%E4%B8%80%E5%8F%A5%E8%AF%9D%E5%B7%B2%E7%BB%8F%E8%AF%B4%E6%98%8E%E4%BA%86%E8%BF%99%E4%B8%80%E7%82%B9%E3%80%82%3CBR%20%2F%3E%E6%88%91%E9%9C%80%E8%A6%81%E5%8A%A8%E6%80%81%E6%9E%84%E9%80%A0%E4%B8%80%E4%B8%AA%E6%9F%A5%E8%AF%A2%E5%AD%97%E7%AC%A6%E4%B8%B2%E4%BB%A5%E4%BB%8E%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E6%8F%90%E5%8F%96%E6%95%B0%E6%8D%AE%E3%80%82%20%E6%90%9C%E7%B4%A2%E8%AF%8D%E5%88%97%E8%A1%A8%E5%92%8C%E5%88%97%E5%90%8D%E7%A7%B0%E6%98%AF%E5%8A%A8%E6%80%81%E7%9A%84%E3%80%82%20%E5%AF%B9%E4%BA%8E%E5%85%B6%E4%B8%AD%E4%B8%80%E4%B8%AA%E5%88%97%E5%90%8D%EF%BC%8C%E5%8C%B9%E9%85%8D%E4%B8%8D%E7%B2%BE%E7%A1%AE%EF%BC%8C%E5%9B%A0%E6%AD%A4%E6%88%91%E6%97%A0%E6%B3%95%E4%BD%BF%E7%94%A8%20WHERE%20t1.column1%20IN%20('qwe'%2C%20'rty'...)%20%E7%AD%89%E3%80%82%20%E7%9B%B8%E5%8F%8D%EF%BC%8C%E6%88%91%E5%BF%85%E9%A1%BB%E4%BD%BF%E7%94%A8%20LIKE%20%E5%85%B3%E9%94%AE%E5%AD%97%E5%92%8C%E9%9D%9E%E5%B8%B8%E5%BA%9E%E5%A4%A7%E7%9A%84%E7%BB%93%E6%9E%84%E3%80%82%20%E6%88%91%E6%AD%A3%E5%9C%A8%E5%AF%BB%E6%89%BE%E4%B8%80%E7%A7%8D%E5%9C%A8%E8%AF%AD%E6%B3%95%E4%B8%8A%E7%B1%BB%E4%BC%BC%E4%BA%8E%EF%BC%88%E5%8F%8C%E5%85%B3%E8%AF%AD%EF%BC%89IN%20%E7%9A%84%E6%9E%84%E9%80%A0%E3%80%82%20%E8%AF%A5%E5%85%B3%E9%94%AE%E5%AD%97%E6%98%AF%E2%80%9CSIMILAR%20TO%E2%80%9D%E3%80%82%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-212256%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%A6%82%E4%BD%95%E5%9C%A8%20SQL%20%E6%9F%A5%E8%AF%A2%E4%B8%AD%E7%BC%96%E5%86%99%E5%A4%9A%E4%B8%AA%E2%80%9CContains%E2%80%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-212256%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%BF%E7%94%A8%E7%B1%BB%E4%BC%BC%E4%BA%8E%E3%80%82%20%E5%AF%B9%E4%BA%8E%E8%AF%AD%E6%B3%95%EF%BC%8C%E4%BB%A5%E4%B8%8B%E8%AF%AD%E5%8F%A5%E6%89%A7%E8%A1%8C%E7%9B%B8%E5%90%8C%E7%9A%84%E6%93%8D%E4%BD%9C%E3%80%82%20%E5%BD%93%E7%84%B6%EF%BC%8C%E6%82%A8%E5%BF%85%E9%A1%BB%E5%9C%A8%20JMP%20%E6%9F%A5%E8%AF%A2%E7%94%9F%E6%88%90%E5%99%A8%E8%BF%87%E6%BB%A4%E5%99%A8%E9%83%A8%E5%88%86%E4%B8%AD%E8%BE%93%E5%85%A5%E2%80%9CSIMILAR%20TO%E2%80%9D%E8%AF%AD%E5%8F%A5%E4%BD%9C%E4%B8%BA%E2%80%9C%E8%87%AA%E5%AE%9A%E4%B9%89%E8%A1%A8%E8%BE%BE%E5%BC%8F%E2%80%9D%E3%80%82%20%E6%88%91%E8%AE%A4%E4%B8%BA%E6%82%A8%E6%97%A0%E6%B3%95%E9%80%9A%E8%BF%87%E5%8D%95%E5%87%BB%E7%BA%A2%E8%89%B2%E5%B0%8F%E4%B8%89%E8%A7%92%E8%8F%9C%E5%8D%95%E4%B8%AD%E7%9A%84%E9%A1%B9%E7%9B%AE%E6%9D%A5%E7%94%9F%E6%88%90%E5%AE%83%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CP%20class%3D%221559865335060%22%3EWHERE%20((%22t1%22.column1%20LIKE%20'%25AAA%25')%20OR%20(%22t1%22.column1%20LIKE%20'%25BBB%25'))%3C%2FP%3E%3CP%20class%3D%221559865335060%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%221559865335060%22%3EWHERE%20((%22t1%22.column1%20%E7%B1%BB%E4%BC%BC%E4%BA%8E%20'%25(AAA%7CBBB)%25')%20)%3C%2FP%3E%3C%2FBLOCKQUOTE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-212254%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%A6%82%E4%BD%95%E5%9C%A8%20SQL%20%E6%9F%A5%E8%AF%A2%E4%B8%AD%E7%BC%96%E5%86%99%E5%A4%9A%E4%B8%AA%E2%80%9CContains%E2%80%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-212254%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%A0%E5%88%B0%E5%BA%95%E6%83%B3%E5%81%9A%E4%BB%80%E4%B9%88%EF%BC%9F%E9%80%89%E6%8B%A9%20JMP%20%E6%95%B0%E6%8D%AE%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%9F%90%E4%BA%9B%E8%A1%8C%EF%BC%9F%3C%2FP%3E%3C%2FLINGO-BODY%3E

Use SIMILAR TO. For syntax, the below statements do the same thing. Of course, you'll have to type the "SIMILAR TO" statement in as a "custom expression" in the JMP query builder filters section. I don't think you can generate it by clicking items in the red triangle menu.

---

WHERE (  ("t1".column1 LIKE '%AAA%' ) OR ( "t1".column1 LIKE '%BBB%' ) )

WHERE (  ("t1".column1 SIMILAR TO '%(AAA|BBB)%'  ) )

It's pretty much stated in the first sentence of the question.
I need to dynamically construct a query string to pull data from DB. List of search terms and column name are dynamic. For one of the column names the match is not exact, so I can't use WHERE t1.column1 IN ('qwe', 'rty'...) and so on. Instead, I had to use LIKE keyword and very bulky construct. I was looking for a construct that is similar to (pun intended) IN in syntax. This keyword is 'SIMILAR TO'.

Use SIMILAR TO. For syntax, the below statements do the same thing. Of course, you'll have to type the "SIMILAR TO" statement in as a "custom expression" in the JMP query builder filters section. I don't think you can generate it by clicking items in the red triangle menu.

---

WHERE (  ("t1".column1 LIKE '%AAA%' ) OR ( "t1".column1 LIKE '%BBB%' ) )

WHERE (  ("t1".column1 SIMILAR TO '%(AAA|BBB)%'  ) )

Looks like it's working as promised. It produces identical to my current solution results.

I use it in JSL, where I assemble the query string out of some text and variable. For instance, t1.column1 is also a variable, and I have partial matches for only one of those variables for t1.column1, so I had to use something like this for one variable:

"WHERE(t1.column1 LIKE '%qwe%') OR
(t1.column1 LIKE '%rty%') OR
(t1.column1 LIKE '%asd%') OR
(t1.column1 LIKE '%fgh%') OR
(t1.column1 LIKE '%zxc%')"

making it a pretty complex thing to assemble something like that from stringColumnName = "column1" and searchStringArray = {'qwe', 'rty', 'asd',' fgh', 'zxc'}

While for other column variables it comes to much simpler form of:

"WHERE 
t1."||stringColumnName||" IN (' "||Concat Items(searchStringsArray," ', ' ")||" ' )"

Now, thanks to @WhiteMenCanJMP and his SIMILAR TO this task of assembling dynamic query string is going to be much simpler.

And no worries about custom window - I script that in JSL anyways. Although Custom filter in Query Builder is the fastest way to check syntax anyways.

var data = div.getElementsByClassName("video-js"); var script = document.createElement('script'); script.src = "https://players.brightcove.net/" + data_account + "/" + data_palyer + "_default/index.min.js"; for(var i=0;i< data.length;i++){ videodata.push(data[i]); for(var i=0;i< videodata.length;i++){ document.getElementsByClassName('lia-vid-container')[i].innerHTML = videodata[i].outerHTML; document.body.appendChild(script); catch(e){ /* Re compile html */ $compile(rootElement.querySelectorAll('div.lia-message-body-content')[0])($scope); if (code_l.toLowerCase() != newBody.getAttribute("slang").toLowerCase()) { /* Adding Translation flag */ var tr_obj = $filter('filter')($scope.sourceLangList, function (obj_l) { return obj_l.code.toLowerCase() === newBody.getAttribute("slang").toLowerCase() if (tr_obj.length > 0) { tr_text = "This post originally written in lilicon-trans-text has been computer translated for you. When you reply, it will also be translated back to lilicon-trans-text.".replace(/lilicon-trans-text/g, tr_obj[0].title); try { if ($scope.wootMessages[$rootScope.profLang] != undefined) { tr_text = $scope.wootMessages[$rootScope.profLang].replace(/lilicon-trans-text/g, tr_obj[0].title); } catch (e) { } else { //tr_text = "This message was translated for your convenience!"; tr_text = "This message was translated for your convenience!"; try { if (!document.getElementById("tr-msz-" + value)) { var tr_para = document.createElement("P"); tr_para.setAttribute("id", "tr-msz-" + value); tr_para.setAttribute("class", "tr-msz"); tr_para.style.textAlign = 'justify'; var tr_fTag = document.createElement("IMG"); tr_fTag.setAttribute("class", "tFlag"); tr_fTag.setAttribute("src", "/html/assets/lingoTrFlag.PNG"); tr_fTag.style.marginRight = "5px"; tr_fTag.style.height = "14px"; tr_para.appendChild(tr_fTag); var tr_textNode = document.createTextNode(tr_text); tr_para.appendChild(tr_textNode); /* Woot message only for multi source */ if(rootElement.querySelector(".lia-quilt-forum-message")){ rootElement.querySelector(".lia-quilt-forum-message").appendChild(tr_para); } else if(rootElement.querySelector(".lia-message-view-blog-topic-message")) { rootElement.querySelector(".lia-message-view-blog-topic-message").appendChild(tr_para); } else if(rootElement.querySelector(".lia-quilt-blog-reply-message")){ rootElement.querySelector(".lia-quilt-blog-reply-message").appendChild(tr_para); } else if(rootElement.querySelector(".lia-quilt-tkb-message")){ rootElement.querySelector(".lia-quilt-tkb-message").appendChild(tr_para); } else if(rootElement.querySelector(".lia-quilt-tkb-reply-message")){ rootElement.querySelector(".lia-quilt-tkb-reply-message").insertBefore(tr_para,rootElement.querySelector(".lia-quilt-row.lia-quilt-row-footer")); } else if(rootElement.querySelector(".lia-quilt-idea-message")){ rootElement.querySelector(".lia-quilt-idea-message").appendChild(tr_para); }else if(rootElement.querySelector(".lia-quilt-column-alley-left")){ rootElement.querySelector(".lia-quilt-column-alley-left").appendChild(tr_para); else { if (rootElement.querySelectorAll('div.lia-quilt-row-footer').length > 0) { rootElement.querySelectorAll('div.lia-quilt-row-footer')[0].appendChild(tr_para); } else { rootElement.querySelectorAll('div.lia-quilt-column-message-footer')[0].appendChild(tr_para); } catch (e) { } else { /* Do not display button for same language */ // syncList.remove(value); var index = $scope.syncList.indexOf(value); if (index > -1) { $scope.syncList.splice(index, 1); angular.forEach(mszList_l, function (value) { if (document.querySelectorAll('div.lia-js-data-messageUid-' + value).length > 0) { var rootElements = document.querySelectorAll('div.lia-js-data-messageUid-' + value); }else if(document.querySelectorAll('.lia-occasion-message-view .lia-component-occasion-message-view').length >0){ var rootElements = document.querySelectorAll('.lia-occasion-message-view .lia-component-occasion-message-view')[0].querySelectorAll('.lia-occasion-description')[0]; }else { var rootElements = document.querySelectorAll('div.message-uid-' + value); angular.forEach(rootElements, function (rootElement) { if (value == '212233' && "ForumTopicPage" == "TkbArticlePage") { rootElement = document.querySelector('.lia-thread-topic'); /* V1.1 Remove from UI */ if (document.getElementById("tr-msz-" + value)) { document.getElementById("tr-msz-" + value).remove(); if (document.getElementById("tr-sync-" + value)) { document.getElementById("tr-sync-" + value).remove(); /* XPath expression for subject and Body */ var lingoRBExp = "//lingo-body[@id = " + "'lingo-body-" + value + "'" + "]"; lingoRSExp = "//lingo-sub[@id = " + "'lingo-sub-" + value + "'" + "]"; /* Get translated subject of the message */ lingoRSXML = doc.evaluate(lingoRSExp, doc, null, XPathResult.UNORDERED_NODE_SNAPSHOT_TYPE, null); for (var i = 0; i < lingoRSXML.snapshotLength; i++) { /* Replace Reply/Comment subject with transalted subject */ var newSub = lingoRSXML.snapshotItem(i); /*** START : extracting subject from source if selected language and source language is same **/ var sub_L = ""; if (newSub.getAttribute("slang").toLowerCase() == code_l.toLowerCase()) { if (value == '212233') { sub_L = decodeURIComponent($scope.sourceContent[value].subject); else{ sub_L = decodeURIComponent($scope.sourceContent[value].subject); } else { sub_L = newSub.innerHTML; /*** End : extracting subject from source if selected language and source language is same **/ /* This code is placed to remove the extra meta tag adding in the UI*/ sub_L = sub_L.replace('<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />',''); catch(e){ // if($scope.viewTrContentOnly || (newSub.getAttribute("slang").toLowerCase() != code_l.toLowerCase())) { if ($scope.viewTrContentOnly) { if ("ForumTopicPage" == "IdeaPage") { if (value == '212233') { if( (sub_L != "") && (sub_L != undefined) && (sub_L != "undefined") ){ document.querySelector('.MessageSubject .lia-message-subject').innerHTML = sub_L; if ("ForumTopicPage" == "TkbArticlePage") { if (value == '212233') { if( (sub_L != "") && (sub_L != undefined) && (sub_L != "undefined") ){ var subTkbElement = document.querySelector('.lia-thread-subject'); if(subTkbElement){ document.querySelector('.lia-thread-subject').innerHTML = sub_L; else if ("ForumTopicPage" == "BlogArticlePage") { if (value == '212233') { try { if((sub_L != "") && (sub_L!= undefined) && (sub_L != "undefined")){ var subElement = rootElement.querySelector('.lia-blog-article-page-article-subject'); if(subElement) { subElement.innerText = sub_L; } catch (e) { /* var subElement = rootElement.querySelectorAll('.lia-blog-article-page-article-subject'); for (var subI = 0; subI < subElement.length; subI++) { if((sub_L != "") && (sub_L!= undefined) && (sub_L != "undefined")){ subElement[subI].innerHTML = sub_L; else { try { // rootElement.querySelectorAll('.lia-blog-article-page-article-subject').innerHTML= sub_L; /** var subElement = rootElement.querySelectorAll('.lia-blog-article-page-article-subject'); for (var j = 0; j < subElement.length; j++) { if( (sub_L != "") && (sub_L != undefined) && (sub_L != "undefined") ){ subElement[j].innerHTML = sub_L; } **/ } catch (e) { else { if (value == '212233') { /* Start: This code is written by iTalent as part of iTrack LILICON - 98 */ if( (sub_L != "") && (sub_L != undefined) && (sub_L != "undefined") ){ if(document.querySelectorAll('.lia-quilt-forum-topic-page').length > 0){ if(rootElement.querySelector('div.lia-message-subject').querySelector('h5')){ rootElement.querySelector('div.lia-message-subject').querySelector('h5').innerText = decodeURIComponent(sub_L); } else { rootElement.querySelector('.MessageSubject .lia-message-subject').innerText = sub_L; } else { rootElement.querySelector('.MessageSubject .lia-message-subject').innerText = sub_L; /* End: This code is written by iTalent as part of iTrack LILICON - 98 */ catch(e){ console.log("subject not available for second time. error details: " + e); } else { try { /* Start: This code is written by iTalent as part of LILICON - 98 reported by Ian */ if ("ForumTopicPage" == "IdeaPage") { if( (sub_L != "") && (sub_L != undefined) && (sub_L != "undefined") ){ document.querySelector('.lia-js-data-messageUid-'+ value).querySelector('.MessageSubject .lia-message-subject').innerText = sub_L; else{ if( (sub_L != "") && (sub_L != undefined) && (sub_L != "undefined") ){ rootElement.querySelector('.MessageSubject .lia-message-subject').innerText = sub_L; /* End: This code is written as part of LILICON - 98 reported by Ian */ } catch (e) { console.log("Reply subject not available. error details: " + e); // Label translation var labelEle = document.querySelector("#labelsForMessage"); if (!labelEle) { labelEle = document.querySelector(".LabelsList"); if (labelEle) { var listContains = labelEle.querySelector('.label'); if (listContains) { /* Commenting this code as bussiness want to point search with source language label */ // var tagHLink = labelEle.querySelectorAll(".label")[0].querySelector(".label-link").href.split("label-name")[0]; var lingoLabelExp = "//lingo-label/text()"; trLabels = []; trLabelsHtml = ""; /* Get translated labels of the message */ lingoLXML = doc.evaluate(lingoLabelExp, doc, null, XPathResult.UNORDERED_NODE_SNAPSHOT_TYPE, null); /* try{ for(var j=0;j ,'; trLabelsHtml = trLabelsHtml+'

'+lTex+'

'; var tagHLink = labelEle.querySelectorAll(".label")[j].querySelector(".label-link").href; trLabelsHtml = trLabelsHtml+'

'+lTex+'

'; } catch(e){} */ var labelsLength = document.querySelector(".LabelsList").querySelectorAll(".label").length; var labelSnapshotLength = lingoLXML.snapshotLength; if (labelsLength == labelSnapshotLength){ for (var k = 0; k < lingoLXML.snapshotLength; k++) { //trLabels.push(lingoLXML.snapshotItem(i).textContent); if (k != 0) { //trLabelsHtml = trLabelsHtml + '

,

'; //diffVariable = kValue if(labelEle.querySelectorAll(".label")[k]){ tagHLink = labelEle.querySelectorAll(".label")[k].querySelector(".label-link").href; if ("ForumTopicPage" == "BlogArticlePage") { trLabelsHtml = trLabelsHtml + '

' + lingoLXML.snapshotItem(k).textContent + '

'; else { trLabelsHtml = trLabelsHtml + '

' + lingoLXML.snapshotItem(k).textContent + '

'; catch(e){ catch(e){ if (newSub.getAttribute("slang").toLowerCase() != code_l.toLowerCase()) { if (trLabelsHtml != "") { labelEle.querySelector("ul").innerHTML = ""; labelEle.querySelector("ul").innerHTML = trLabelsHtml; // trLabels = trLabels.split(","); // trLabels = reverseArr(trLabels); // var tagHLink = labelEle.querySelectorAll(".label")[0].querySelector(".label-link").href.split("label-name")[0]; // cELabels = labelEle.querySelectorAll(".label"); // //cELabels = reverseArr(cELabels); // for(var cE=0; cE < trLabels.length; cE++) { // if(trLabels[cE]){ // cELabels[cE].querySelector(".label-link").text = trLabels[cE]; // } // } /* V 2.0:3 = Store not translated reply id */ if (lingoRSXML.snapshotLength == 0) { if ($scope.falseReplyID == "") { $scope.falseReplyID = value; /* Get translated Body of Replies/Comments */ lingoRBXML = doc.evaluate(lingoRBExp, doc, null, XPathResult.UNORDERED_NODE_SNAPSHOT_TYPE, null); /* Replace Reply/Comment Body with translated Body */ for (var i = 0; i < lingoRBXML.snapshotLength; i++) { var newBody = lingoRBXML.snapshotItem(i); /* try { var cPTags = newBody.getElementsByTagName("p"); var searchText = "