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 is a Mapplet?
How many tables can you join in sql?
Is sql an operating system?
What is on delete restrict?
When is the update_statistics command used?
What are the two virtual tables available at the time of database trigger execution?
How to execute a stored procedure?
What is meant by truncate in sql?
What is varchar data type in sql?
Can you join views in sql?
what is bcp? When does it used? : Sql dba
How do you go back in sql?
What are different functions in sql?
what is 'mysqladmin' in mysql? : Sql dba
How do I add a primary key to a table?