What are all the difference between Like and Contains ?
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
Do we need to create index on primary key?
Can you join a table to itself?
Difference between table function and pipelined function?
What is the usage of when clause in trigger?
What is the command used to fetch first 5 characters of the string?
Which is better join or subquery?
explain the difference between myisam static and myisam dynamic. : Sql dba
how are mysql timestamps seen to a user? : Sql dba
Which is better varchar or nvarchar?
Is pl sql and postgresql same?
Is sql difficult?
how do you login to mysql using unix shell? : Sql dba
How do I find duplicates in two columns?
Explain what is sql*plus?
How do I truncate a sql log file?