Mysql select query not retrieving decimal value

user_6698796 0
Viewed 100

I have sizes table with decimal and non-decimal value so I want to fetch data as per requirement and I have written mysql query for this, but getting empty result even data is present.

Note:I don't want to use LIKE clause

Table:

id      size
1       17X23
2       28.3X39.8 
3       25X39.8
4       28X36

Mysql query:

Select * from sizes where size='28.3X39.8'; // X is uppercase 'X' alphabet I have used to mention width X height

Output: empty result

mysql
2 Answers

could be you have some hidden space

select Select * from sizes where trim(size)='28.3X39.8';

or

select Select * from sizes where trim(replace(size,' ',''))='28.3X39.8';

or

select Select * from sizes where upper(trim(replace(size,' ','')))=uppper(trim('28.3X39.8'));
user_35223120

You can try this:

select * from sizes where trim(upper(size))='28.3X39.8';
user_149990910
Related