select distinct search from globalSearch where 1=1 order by search limit 0,40

Corbet

CR-101-Zebra
CR-102-Zebra
CR-103-Ivory
CR-104-Natural