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
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is a temporal table?
What are the different types of constraints?
Can we call stored procedure in function?
What is the difference between sql and mysql?
How many row comparison operators are used while working with a subquery?
what is commit? : Sql dba
what is 'mysqlcheck'? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What are expressions?
What is sql stand for?
What is sql and also describe types of sql statements?
Is not null in sql?
How do I kill a query in postgresql?
What is break?