CODEWITHSUNDEEP
mysqlsqloracle11goracle-sqldeveloper
shekhar_rawat
shekhar_rawat

Reputation: 63

Find the SPECIFIC records in the table which have white space on second place only?

I have record table for xyz . There is a column like

0025336625
0036625336
9986698852
0 22336652
1 32236633
9333265556
8 44555223

So I only need these records fetch from the table which is in Bold only .

Upvotes: 2

Views: 37

Answers (1)

ScaisEdge
ScaisEdge

Reputation: 133370

You can use substr for filter the column 

select * 
from my_table 
where substr(my_column, 2, 1 ) = ' ';

Upvotes: 4

Related Questions