What are all the difference between Like and Contains ?
Answer Posted / 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 View All Answers
What are views in sql?
How do you know if a relationship is 2nf?
explain advantages of innodb over myisam. : Sql dba
What are the types of functions in sql?
Which sql statement is used to return only different values?
What are sql ddl commands?
How do you update a value in sql?
what is error ora-03113: end-of-file on communication channel?
What is a null value?
List and explain the different types of join clauses supported in ansi-standard sql?
What are different types of sql commands?
What is program debugging?
Is it possible for a table to have more than one foreign key?
Can we use loop in sql?
What are sql commands?