Step 1 :
Create database BMC
Step 2:
create table Client_table_news
(
Cids bigint,
Cname varchar(50),
Ccity varchar(200),
CPrice float
);
Step 3 :
Insert Into Client_table_news values(1,'VIRAJ','MUMBAI',15000.00)
Insert Into Client_table_news values(2,'RAJ','DELHI',10000.00)
Insert Into Client_table_news values(3,'ANIL','PUNE',12000.00)
Insert Into Client_table_news values(4,'SUNIL','MUMBAI',9000.00)
Insert Into Client_table_news values(5,'SHERYAS','JAIPUR',11000.00)
Insert Into Client_table_news values(6,'AJAY','MUMBAI',16000.00)
select *from Client_table_news
Step 4 :
SELECT *FROM Client_table_news
WHERE Ccity LIKE 'M%';
SELECT *FROM Client_table_news
WHERE Ccity LIKE '%I';
SELECT * FROM Client_table_news
WHERE Ccity LIKE '%MUM%';
SELECT * FROM Client_table_news
WHERE Ccity LIKE '_UM%';
SELECT * FROM Client_table_news
WHERE Ccity LIKE 'M_%_%';
SELECT * FROM Client_table_news
WHERE Ccity LIKE 'M%I';
SELECT * FROM Client_table_news
WHERE Ccity NOT LIKE 'M%';
