Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What are all the difference between Like and Contains ?

Answers were Sorted based on User's Feedback



What are all the difference between Like and Contains ?..

Answer / 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

What are all the difference between Like and Contains ?..

Answer / santosh acharya

Select * from myTable where textField like '%Cats and Dogs%'

Select * from myTable where CONTAINS(textField, '"Cats and
Dogs"')

Both options will only return rows that contain the exact
phrase "Cats and Dogs", neither will return records that
contain either "Cats" or "Dogs" in them.

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More SQL PLSQL Interview Questions

what tools available for managing mysql server? : Sql dba

0 Answers  


What is bulk collections?

2 Answers  


What is the difference between left join and left outer join?

1 Answers  


What does pl sql developer do?

0 Answers  


What are user defined functions?

0 Answers  






What is the max nvarchar size?

0 Answers  


Which sql most popular?

0 Answers  


Wat is SGA ?

3 Answers   ABB,


I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  


What is sorting in sql?

0 Answers  


What is localdb mssqllocaldb?

0 Answers  


When can we use the where clause and the having clause?

0 Answers  


Categories