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

Peony

FAI-1-MULTI_01
FAI-2-GRAY
FAI-3-SILVER_01
FAI-4-SLATE_01
FAI-5-SPICE_01
FAI-6-CHARCOAL_01
FAI-7-AZURE_01