mysql select int as currency or convert int to currency format?

by

FORMAT() function:
http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_format

SELECT CONCAT('$', FORMAT(val, 2)) ... ;

More Related Contents:

  1. NOT LIKE not working with SHOW [duplicate]
  2. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  3. MySQL – Rows to Columns
  4. How to define a custom ORDER BY order in mySQL
  5. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  6. How to get the number of days of difference between two dates on MySQL?
  7. MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
  8. conditional join in mysql
  9. a count for each join – optimisation
  10. How to grant all privileges to root user in MySQL 8.0
  11. MySQL Group by SUM
  12. How to remove leading and trailing whitespace in a MySQL field?
  13. How to reset the root password in MySQL 8.0.11?
  14. How does MySQL CASE work?
  15. What characters have to be escaped to prevent (My)SQL injections?
  16. How to save MySQL query output to excel or .txt file? [duplicate]
  17. MySQL: Set user variable from result of query
  18. Is there a naming convention for MySQL?
  19. Is there any performance gain in indexing a boolean field?
  20. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  21. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  22. How to swap values of two rows in MySQL without violating unique constraint?
  23. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  24. Storing images in MySQL [closed]
  25. Would it help to add index to BIGINT column in MySQL?
  26. Query to count the number of tables I have in MySQL
  27. How to kill MySQL connections
  28. `MODIFY COLUMN` vs `CHANGE COLUMN`
  29. INSERT INTO Table from multiple tables
  30. How to solve MySQL max_user_connections error

Leave a Comment