All language subtitles for 6. SUBSTRING

Next is the substring function
1

Substring function is used to extract a substring of a string
2

So for example, if you have a long string and you want to take out a part of that string
3

That is where substring will help you
4

The syntax for substring is you write substring and within the parentheses
5

You write the string first
6

Then you mention
7

From the starting position so you will give the starting position after writing the keyword from
8

After that you can mention the length of characters
9

That you want after the starting position
10

So for this much length
11

Let us look at an example to understand the substring function
12

If you remember in the customer table customer id has two parts
13

The first part is the two characters these two characters are the first characters of the customers name first name
14

Last name
15

After those two characters that is a hyphen
16

And after that hyphen there are five numbers which may be randomly generated
17

If you want to
18

Segregate these two parts
19

So, if you want to get the initials of the customer
20

Separately into one column and if you want to get the unique identifying number
21

Into another column
22

You can do that using the substring
23

with the first select statement I am writing customer ID customer name
24

and I am getting the substring, the first two characters of the customer ID
25

You can see the syntax here substring
26

I will mention the column name
27

For 2 I have not mentioned from
28

Because
29

From
30

By default it will be the first character if I want to get it to some other position I have to mention the
31

From keyword
32

This column I have named as customer group
33

From customer table where substring
34

Customer ID for 2 is equal to AB so what this will give me is
35

Only those
36

Records with customer ID is starting with characters AB
37

The 2nd select statement
38

I am taking out the five randomly generated
39

Digits
40

To do that
41

I have to start from the 4th position
42

In the first two position is the these two characters
43

The third position is taken by
44

The hyphen
45

So the number starts from 4th position
46

and the number has
47

Length of 5 characters
48

So there are five different
49

Numbers
50

I'll take out this
51

5
52

Characters as a substring
53

Let us go and write these two queries to get the two
54

Parts of the customer ID
55

So select customer ID customer name
56

and Substring
57

Mention the string
58

Which will be the column name
59

For two characters
60

Name this column as customer group
61

This all is coming from table
62

Customer
63

Where
64

The first two characters
65

are AB. so I will copy this substring down and this should be same as AB
66

Let us select this query and run it
67

You can see I have only those
68

Customers where customer ID is starting with AB
69

and the customer group column has that
70

Substring
71

The first two characters of the customer ID
72

so it is AB for all these customers
73

Now let us take out the last
74

Five digits
75

These are the five digits of the customer ID
76

We want to take these out into a separate column. Let us go and write the query for that
77

Select
78

Customer ID customer name
79

and substring
80

Customer ID
81

From 4
82

it starts from the fourth character for 5 characters
83

as
84

Customer number
85

From customer table
86

Where substring
87

Customer ID for 2 is AB
88

So for this customer group only we find out the
89

Last five digits
90

So it should contain 10165 for the First row
91

Let's select and run this query
92

So can see
93

10165 is the value mentioned here
94

So this customer num column has the last five digits
95

of the customer ID
96

This is how we use substring to take out a
97

Second string
98

From a primary string