jeudi 28 juillet 2016

Select WHERE Cast - Maintain Order

I am trying to maintain the order of the fields here. Any thoughts? This produces a result, but the results come out in varying order.

SELECT value FROM field_one WHERE cast(field_number as BINARY(6)) IN

(44,121.3,121.6,77,78,3,2.1,2.3,2.4,2.5) AND lead_id=1234 AND form_id=123

Aucun commentaire:

Enregistrer un commentaire