Custom Search
 


Using Single-Row Functions



This section explains how to use MySQL functions. Using functions inside your SQL statement properly can greatly save coding on the caller side such as PHP.


1. Using String Functions, Part 1


2. Using String Functions, Part 2


3. Using String Functions, Part 3


4. Using MySQL Date and Time Functions, Part 1


5. Using MySQL Date and Time Functions, Part 2


6. Using MySQL Date and Time Functions, Part 3


7. Using MySQL Control Flow Functions


8. Using MySQL Conversion Functions


9. Using MySQL Comparison Functions


10. Using Aggregate Functions in MySQL


11. MySQL RANK() function


12. MySQL DENSE_RANK() function


13. MySQL ROW_NUMBER() function


14. Compare RANK(), DENSE_RANK(), and ROW_NUMBER() function


15. Using LIMIT and OFFSET to Page Thru Query Result in MySQL


16. Using LIMIT, SQL_CALC_FOUND_ROWS and FOUND_ROWS() to Page Thru Query Result in MySQL


17. Use LEAST function to find the SMALLEST value from multiple arguments


18. How to make case-sensitive comparison in MySQL


19. Use GREATEST function to find the LARGEST value from multiple arguments


20. MySQL MID() function with examples


21. MySQL LOCATE() function with examples


22. MySQL SUBSTR() function with examples


23. MySQL POSITION() function with examples


24. How to use MySQL REPLACE function in SELECT and UPDATE queries


25. Numeric Functions in MySQL


26. Miscellaneous Functions in MySQL


Back to Tutorial Index: MySQL Database How-to Articles and Tutorials

Copyright © 2024 GeeksEngine.com. All Rights Reserved.

This website is hosted by HostGator.

No portion may be reproduced without my written permission. Software and hardware names mentioned on this site are registered trademarks of their respective companies. Should any right be infringed, it is totally unintentional. Drop me an email and I will promptly and gladly rectify it.

 
Home | Feedback | Terms of Use | Privacy Policy