Like is used with where clause to search,update, and delete a record using

What keyword does an SQL SELECT statement use for a string
search?

Question Posted / kirtish srivastava

2 Answers
8132 Views
I also Faced
E-Mail Answers

Like is used with where clause to search,update, and delete a record using wild cards.

Example:-
To Search;-

select * from Employee where Name like 'a%'

Note;- Search all records whose employee name is stared from a character.

To Update:-

update Employee set Name='amit' where Name like 'a%'

update all records with name amit whose employee name is started from a character.

To Delete:-

delete from Employee where Name like 'a%'

Delete all records whose employee name is started from a Character.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is db2 bind process?

1183

How to compare data between two tables in db2?

1033

How many types of page locks can be held in db2?

996

How do I connect my db2 database to ibm?

988

Which are the db2 tools to protect integrity of the database?

1073

Can we insert update delete in view?

912

Explain db2.

993

What is the latest version of ibm db2?

1203

How can you count the number of rows from a table tab?

1043

What is difference between rollback and commit?

1094

How to take backup of table in db2?

1023

What is difference between alias and synonym in db2?

1072

What is sqlca’s maximum length?

1104

How do I change the column size in db2?

1084

What is a system catalog table in db2?

1104