WHERE Not in list

3 posts by 2 authors in: Forums > CMS Builder
Last Post: September 23, 2020   (RSS)

By Djulia - September 22, 2020 - edited: September 22, 2020

Hi Ciaran

You can try :

$ExcludeItems = "110, 98";
$ExcludeItems = explode(",", $ExcludeItems); //Split a string by a string

`num` NOT IN(".mysql_escapeCSV($ExcludeItems).") 
Cheers,
Djulia

By ciaranmac - September 23, 2020

Hi Djulia,

That worked for me. Thanks very much for replying.

Cheers,

Ciaran