This lesson covers all scalar functions from the course that deal with strings:
CONCAT(text1, text2, …)
CONCAT() functions accept the arbitrary number of arguments and joins them together.
It’s really useful to generate URL-s from the database records. Here’s an example of such a query:
SELECT id, name, genre, CONCAT('https://admin.bindle.com/books/', id, '/edit') AS admin_tool_url FROM books
LENGTH() function returns the number of characters in the text input:
SELECT LENGTH(first_name) FROM users ORDER BY 1 DESC
Sign up and check out 36 free lessons and exercises.
About SQL Habit
Hi, it’s Anatoli, the author of SQL Habit.
SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst and solve real-life challenges from Business, Marketing, and Product Management.
SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work.