SELECT count(distinct cle4) FROM zfleuriste_josepha WHERE cle4 REGEXP '[[:<:]]Lys[[:>:]]' AND (prix>=1) AND cle1 REGEXP '[[:<:]]FLEURS[[:>:]]'Unknown column 'cle1' in 'where clause'