MySQL String Functions

 How to work List of String Function in MySql:


Code:

CREATE TABLE personal(

id INT NOT NULL,

name VARCHAR(50) NOT NULL,

    percentage INT NOT NULL,

age INT NOT NULL,

gender VARCHAR(1) NOT NULL,

city INT NOT NULL,

    courses INT NOT NULL,

    PRIMARY KEY (id),

FOREIGN KEY (city) REFERENCES City (cid),

    FOREIGN KEY (courses) REFERENCES Courses (course_id)  

);

INSERT INTO personal(id,name,percentage,age,gender,city,courses)

VALUES

(1,"Aqib","45","13","M",1,1),

(2,"Khadija","56","21","F",2,2),

(3,"Salman Khan","62","20","M",1,1),

(4,"Aqeela","47","18","F",3,1),

(5,"Saqib","74","22","M",1,3),

(6,"Abraham","64","21","M",2,2),

(7,"Shahid","52","20","M",1,3);

String Functions

SELECT id, UPPER(name) AS Name , percentage
FROM students;

SELECT id, UCASE(name) AS Name , percentage
FROM students;

SELECT id, LOWER(name) AS Name , percentage
FROM students;

SELECT id, LCASE(name) AS Name , percentage
FROM students;

SELECT id, name,CHARACTER_LENGTH(name) AS Characters
FROM students;

SELECT id, name,CHAR_LENGTH(name) AS Characters
FROM students;

SELECT id, name,LENGTH(name) AS Characters
FROM students;

SELECT id, CONCAT(name, " " ,percentage) AS Name
FROM students;

SELECT id, CONCAT(name, " - " ,percentage) AS Name
FROM students;

SELECT CONCAT("Sheikh","Aqib","Saeed") AS Name;

SELECT CONCAT_WS("Sheikh","Aqib","Saeed") AS Name;

SELECT CONCAT_WS(" - ","Sheikh","Aqib","Saeed") AS Name;

SELECT "    Sheikh Aqib    " AS Name;

SELECT LTRIM("    Sheikh Aqib    ") AS Name;

SELECT "    Sheikh Aqib                 " AS Name;

SELECT RTRIM("    Sheikh Aqib          ") AS Name;

SELECT TRIM("    Sheikh Aqib          ") AS Name;

SELECT POSITION("M" IN "Sheikh Aqib") AS Name;

SELECT POSITION("Baba" IN "Sheikh Aqib") AS Name;

SELECT POSITION("a" IN "Sheikh Aqib Baba") AS Name;

SELECT INSTR("Sheikh Aqib Baba","a") AS Name;

SELECT INSTR("Sheikh Aqib Baba","Baba") AS Name;

SELECT INSTR("Sheikh Aqib Baba","She") AS Name;

SELECT LOCATE("hoo","Sheikh Aqib Baba") AS Name;

SELECT LOCATE("a","Sheikh Aqib Baba") AS Name;

SELECT LOCATE("a","Sheikh Aqib Baba",3) AS Name;

Comments