Selecting a float in MySQL

by

Casting to a decimal worked for me:

SELECT * FROM table WHERE CAST(price AS DECIMAL) = CAST(101.31 AS DECIMAL);

However, you may want to consider just making the price column a DECIMAL in the first place. DECIMAL is generally considered to be the best type to use when dealing with monetary values.

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. which is better every user have a table or just a row [closed]
  3. save user images in MYSQL database by which method? [closed]
  4. PHP – Change value y,n in database [closed]
  5. PDOException SQLSTATE[HY000] [2002] No such file or directory
  6. Many-to-many relationships examples
  7. PDO get the last ID inserted
  8. strange character encoding of stored data , old script is showing them fine new one doesn’t
  9. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  10. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  11. How to upload images into MySQL database using PHP code
  12. Importing CSV data using PHP/MySQL
  13. How to loop through a mysql result set
  14. MySQL check if a table exists without throwing an exception
  15. Maximum execution time in phpMyadmin
  16. Mysql No connection could be made because the target machine actively refused it
  17. Replacing mysql_* functions with PDO and prepared statements
  18. PDO::PARAM for type decimal?
  19. Is there any way to check the performance of mysql Indexing
  20. phpmyadmin automatic logout time
  21. MySQL skipping first row
  22. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  23. Fatal error: Call to undefined function mysqli_result()
  24. Laravel nested relationships
  25. Selecting all fields except only one field in mysql [duplicate]
  26. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  27. mysql injection damages?
  28. MySQL ORDER BY rand(), name ASC
  29. Auto Increment skipping numbers?
  30. How to get last inserted id from table MySQL [duplicate]

Leave a Comment