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

0 votes
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?
May 28, 2019 in Database by Santanu
236 views

1 answer to this question.

0 votes

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,

answered May 28, 2019 by sampriti
• 1,120 points

Related Questions In Database

0 votes
1 answer

I have to build a school website How can i connect databases to the instance (ec2) and what is the best AMI for my webserver INAWS ???

Hi@Trinu, I don't think your database is depends ...READ MORE

answered May 4, 2020 in Database by MD
• 95,220 points
146 views
0 votes
1 answer

How do I kill all the processes in Mysql “show processlist”?

Hello kartik, Mass killing operation saves time. Do it ...READ MORE

answered May 4, 2020 in Database by Niroj
• 82,760 points
322 views
0 votes
2 answers

How to send data to my database from html and css Contact Us Form?

Hello @Sign, It is simple to create contact ...READ MORE

answered Aug 4, 2020 in Database by Niroj
• 82,760 points
5,381 views
0 votes
1 answer

Is it possible to access Couchbase by terminal?

What you want to accomplish isn't possible ...READ MORE

answered Apr 29, 2018 in DevOps & Agile by DareDev
• 6,890 points
159 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by Parth
• 4,630 points
649 views
0 votes
1 answer
+1 vote
3 answers

How do I check and export sonarqube analysis reports in embedded db?

Browse to sonarqube web instance to access ...READ MORE

answered Jul 2, 2018 in DevOps Tools by DareDev
• 6,890 points
19,119 views
0 votes
1 answer

How can I check my all existing table in MySQL database?

Hi Pratik, I understand your problem regarding this ...READ MORE

answered Jul 1, 2019 in Database by sampriti
• 1,120 points
394 views
0 votes
1 answer

How can I change my existing database name?

Hey Partha, I understand your problem, I think this ...READ MORE

answered Jul 4, 2019 in Database by sampriti
• 1,120 points
153 views