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

Bella

5496-Ivory-Blue
5497-Blue-Ivory
5497-Ivory-Grey
5498-Ivory-Anthracite
5498-Grey-Blue
5499-Ivory
5499-DeepBlue
5500-Anthracite
5500-Ivory-Blue
5500-Grey-Ivory