MySQL case insensitive searching (don't use LOWER)
00:45 Structure of the “people” table
01:17 Where is AAron
01:40 Collations in MySQL
03:18 Experimenting with collations
04:53 Obfuscating your indexes
07:36 Outro (it’s very good)
To learn more about charsets and collations, we have a blog post you might find interesting: https://planetscale.com/blog/mysql-charsets-collations.
To learn more about MySQL, check out the full course at https://planetscale.com/mysql
📚 Learn more about PlanetScale
• Website: https://planetscale.com/
• Docs: https://docs.planetscale.com/
——————————————————
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscaledata
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale/
Comments are closed.