MySQL Workbench

MySQL SUBSTR() Function

The substr() is a String function of MySQL. This function returns the substring from the given string.

Syntax

select substr(Str, pos);
Select substr(Str from pos);
Select substr(Str, pos, len);
Select substr(Str from pos for len);

Parameter:

Str: Main string

Len: length for substring

Pos: position the start the substring from the given string.

Example 1

Output:

Example 2

Output:

Example 3

Output:

Example 4

Output:

Next TopicMySQL String

← prev next →

Latest Courses

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

[email protected].

Python

AI, ML and Data Science

Java

B.Tech and MCA

Web Technology

Software Testing

Technical Interview

Java Interview

Web Interview

Database Interview

Company Interviews

MySQL Tutorial

MySQL Workbench

User Management

MySQL Database

Table & Views

MySQL Queries

MySQL Indexes

MySQL Clauses

MySQL Privileges

Control Flow Function

MySQL Conditions

MySQL Join

MySQL Key

MySQL Triggers

Aggregate Functions

MySQL Misc

MySQL Globalisation

Regular Expressions

FULLTEXT Search

Differences

Interview Questions

MySQL Date/Time Functions

MySQL Math Functions

MSQL String Functions

MySQL SUBSTR() Function

Syntax

Parameter:

Example 1

Example 2

Example 3

Example 4

Latest Courses

Contact info

Follow us

Tutorials

Interview Questions

Online Compiler