Summary
In this chapter, we have covered several of MySQL's string functions and ways to use them in Python. We have seen:
- How to concatenate two or more strings
- Ways to return only part of a string, leaving the larger string behind
- How to trim whitespaces from around a value
- Mysql's functions for replacing and inserting values into others
- How to form regular expressions for MySQL
- Ways to locate strings within other strings
- How to calculate the length of a value
- Ways to work with both numbers and character values to nuance raw data
- How to write functions for MySQL and use them in Python
In the next chapter, we will look at how to access the MySQL's metadata from within Python.
Get MySQL for Python now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
