Interested to Buy Any Domain ? << Click Here >> for more details...
What are all the difference between Like and Contains ?
- 2 Answers
- 10848 Views
- LG Soft, I also Faced
- E-Mail Answers
Answer Posted / rubyna
Like gives additional option of specifying exact
string/character position in the text. eg. if we want to
search all words having second letter 'a', we can use like,
but cannot use contain-
select * from emp where emp.name like '_a%'.
We don't have corresponding statement with contains.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is anonymous block in sql?
what is a constraint? Tell me about its various levels. : Sql dba
What is rename in sql?
What are instead of triggers?
what is meant by nl2br()? : Sql dba
What does (+) mean in sql joins?
What is offset and limit in sql?
How do I sort a table in sql?
Which join is like an inner join?
how to show all tables with 'mysql'? : Sql dba
Differentiate between pl/sql and sql?
What is sql select statement?
What are the different types of functions in sql?
Which one is better subquery or joins?
How many scalar data types are supported in pl/sql?
