Working with Strings in MySQL (four functions)
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: / planetscale
• Discord: / discord
• TikTok: / planetscale
• Twitch: / planetscale
• LinkedIn: / planetscale
Смотрите видео Working with Strings in MySQL (four functions) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь PlanetScale 30 Апрель 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,719 раз и оно понравилось 104 людям.