Watch Ben cover 4 string functions in MySQL, including CONCAT, SUBSTRING_INDEX, LOCATE, and SOUNDEX.
The CONCAT function allows you to concatenate strings together! This is nothing new for an experienced programmer, but this function can come in handy in many scenarios in MySQL.
SUBSTRING_INDEX can be used to grab substrings based on the number of occurrences of a token. This is useful when doing processing with things like, paths, URLs, or CSV data.
LOCATE allows you to locate the index of one string within another! This can help as a way to put additional sorting or constraints on searches.
Finally, the SOUNDEX function produces strings representing the sound of a work in spoken English. It's a bit of a niche function, but there are a few contexts where knowing this may be useful!
To learn more about PlanetScale, head to https://planetscale.com/youtube!
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscale
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale
