I've got a really weird issue with a SQL SELECT query. See below:
SELECT usd FROM glinks_Costs WHERE original_currency = "gbp" and amount = 0.1
It gives me no results. Even though I can see the data in the table (side-by-side in the pic I posted above).
I'm not a mySQL novice - but this one has got me stumped. If I do the same query, but with a large number, i.e:
SELECT usd FROM glinks_Costs WHERE original_currency = "gbp" and amount = 5.25
The issue seems to occur as soon as I go below 1. The field is a FLOAT, so I'm not sure whats going on