Question { 8133 }

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

Answer

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.