How will I get all the rows from my table where name starts with s and ending with I

Question

Hi,

I am facing a problem when I want to fetch all the data from my table where name starts with 's' and end with 'I'.

Can you please help me out with the right query?

Answer 1

Hi Santanu,

I understand your problem,

You can try this query to fetch your data,

select * from tablename where name like 'S%I';


The query will work like,

 First, it will take all the names which will have 'S' as the First letter and then It will check for the last letter  'I' and then it will show the result.

I hope this answer will help you,

Thank you,