Interested to Buy Any Domain ? << Click Here >> for more details...
What are all the difference between Like and Contains ?
- 2 Answers
- 10720 Views
- LG Soft, I also Faced
- E-Mail Answers
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 the difference between python and sql?
Which data dictionary views have the information on the triggers that are available in the database?
How many types of relationship are there?
what is sql profiler? : Sql dba
Why does sql need a server?
Where is pl sql used?
What is row_number () in sql?
In what condition is it good to disable a trigger?
How are functions and procedures called in PL/SQL?
What is a schema? How is it useful in sql servers?
How do you concatenate in sql?
how to get help information from the server? : Sql dba
What is the difference between an inner join and an outer join?
What is clause?
What is string data type in sql?
