Why string manipulation is common in MySQL

Introduction

String manipulation helps us change and work with text data easily. It is common because many databases store names, addresses, and messages as text.

When you want to clean up user input like removing extra spaces.

When you need to extract parts of a text, like getting the first name from a full name.

When you want to combine text from different columns into one.

When you need to search for specific words or patterns inside text.

When formatting data for reports or display, like changing case or adding symbols.

Syntax

MySQL

SELECT function_name(column_name) FROM table_name;

Replace function_name with the string function you want, like UPPER, LOWER, SUBSTRING, or CONCAT.

Use string functions inside SELECT to change or get parts of text.

Examples

Changes all letters in the 'name' column to uppercase.

MySQL

SELECT UPPER(name) FROM users;

Gets the first 5 characters from the 'address' column.

MySQL

SELECT SUBSTRING(address, 1, 5) FROM customers;

Joins first and last names with a space between.

MySQL

SELECT CONCAT(first_name, ' ', last_name) FROM employees;

Sample Program

This creates a table with names, then selects the names in uppercase and the first 5 letters of each name.

MySQL

CREATE TABLE people (id INT, full_name VARCHAR(50));
INSERT INTO people VALUES (1, 'Alice Johnson'), (2, 'Bob Smith');
SELECT UPPER(full_name) AS upper_name, SUBSTRING(full_name, 1, 5) AS short_name FROM people;

Important Notes

String functions can be combined to do more complex tasks.

Be careful with string length and indexes to avoid errors.

Summary

String manipulation is used to handle and change text data in databases.

It helps clean, extract, combine, and format text easily.

Common functions include UPPER, LOWER, SUBSTRING, and CONCAT.