1. Using String Functions, Part 1

   1. ASCII
   2. BIN
   3. BIT_LENGTH
   4. CHAR_LENGTH
   5. CHAR
   6. CHARACTER_LENGTH
   7. CONCAT
   8. CONCAT_WS
   9. ELT
   10. EXPORT_SET
   11. FIELD
   12. FIND_IN_SET
   13. FORMAT
   14. HEX
   15. INSERT

2. Using String Functions, Part 2

1. INSTR
2. LCASE
3. LEFT
4. LENGTH
5. LOAD_FILE
6. LOCATE
7. LOWER
8. LPAD
9. LTRIM
10. MAKE_SET
11. MID
12. OCTET_LENGTH
13. ORD
14. POSITION
15. QUOTE

3. Using String Functions, Part 3

1. REPEAT
2. REPLACE
3. REVERSE
4. RIGHT
5. RPAD
6. RTRIM
7. SOUNDEX
8. SPACE
9. STRCMP
10. SUBSTR
11. SUBSTRING
12. SUBSTRING_INDEX
13. TRIM
14. UCASE
15. UNHEX
16. UPPER

4. Using Date and Time Functions, Part 1

1. DATEADD
2. ADDTIME
3. CONVERT_TZ
4. CURDATE
5. CURRENT_DATE
6. CURRENT_TIME
7. CURRENT_TIMESTAMP
8. CURTIME
9. DATE_ADD

5. Using Date and Time Functions, Part 2

1. DATE_FORMAT
2. DATE_SUB
3. DATE
4. DATEDIFF
5. DAY
6. DAYNAME
7. DAYOFMONTH
8. DAYOFWEEK
9. DAYOFYEAR
10. EXTRACT
11. SUBSTRING
12. FROM_DAYS
13. FROM_UNIXTIME
14. GET_FORMAT
15. HOUR
16. LAST_DAY
17. LOCALTIME
18. LOCALTIMESTAMP
19. MAKEDATE
20. MAKETIME

6. Using Date and Time Functions, Part 3

1. MICROSECOND
2. MINUTE
3. MONTH
4. MONTHNAME
5. NOW
6. PERIOD_ADD
7. PERIOD_DIFF
8. QUARTER
9. SEC_TO_TIME
10. SECOND
11. STR_TO_DATE
12. SUBDATE
13. SUBTIME
14. SYSDATE
15. TIME_FORMAT
16. TIME_TO_SEC
17. TIME
18. TIMEDIFF
19. TIMESTAMP
20. TIMESTAMPADD
21. TIMESTAMPDIFF
22. TO_DAYS
23. UNIX_TIMESTAMP
24. UTC_DATE
25. UTC_TIME
26. WEEK
27. WEEKDAY
28. WEEKOFYEAR
29. YEAR
30. YEARWEEK

7. Using Control Flow Functions

1. CASE
2. IF
3. IFNULL
4. NULLIF

8. Using Conversion Functions

1. CONVERT
2. CAST
3. BINARY

9. Using Comparison Functions

1. COALESCE
2. GREATEST
3. INTERVAL
4. ISNULL
5. LEAST

10. Using Numeric Functions

11. Using Miscellaneous Functions

12. Using LIMIT and SQL_CALC_FOUND_ROWS and FOUND_ROWS() to Page Thru Query Result

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