mysql දන්න කෙනෙක්

[RusiruDon]

+-----------+-----------+----------+------------+--------+------+
| StudentID | FirstName | Surname | DOB | Gender | Age |
+-----------+-----------+----------+------------+--------+------+
| 1001 | Kate | West | 1994-10-12 | F | 24 |
| 1002 | Julin | McLain | 1995-07-03 | F | 23 |
| 1003 | Tom | Smith | 1994-12-24 | M | 24 |
| 1004 | Mark | Foster | 1996-11-05 | M | 22 |
| 1005 | Jane | Knight | 1995-06-17 | F | 23 |
| 1006 | Matt | Smith | 1995-12-24 | M | 23 |
| 1007 | Karen | Edwards | 1995-07-03 | M | 23 |
| 1008 | John | Williams | 1996-11-15 | M | 22 |
| 1009 | Allison | Cambell | 1994-10-10 | M | 24 |
| 1010 | Shirley | Thomas | 1995-04-15 | F | 23 |
+-----------+-----------+----------+------------+--------+------+


Display all the details of students whose surname contains ‘i’ as the third letter.

 

[KasunKDP]

where Surname like '___i%'

 

[nalaka526]

Select * from Students
where SUBSTRING(Surname, 3, 1) = 'i'

http://sqlfiddle.com/#!9/53556c/3

 

[Capital_M]

SELECT * FROM table WHERE SUBSTR(Surname, 3, 1) = 'i'