Interested to Buy Any Domain ? << Click Here >> for more details...
What are all the difference between Like and Contains ?
- 2 Answers
- 11005 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
Describe different types of general function used in sql?
What normalization means?
Which are sql * plus commands?
When sql appeared?
What is string data type in sql?
What are sql functions? Describe in brief different types of sql functions?
What are the advantages of pl sql?
How do I send sql query results to excel?
Enlist the data types that can be used in pl/sql?
how many ways to get the current time? : Sql dba
Does pdo prevent sql injection?
Is null operator in sql?
What is dml with example?
What is the difference between explicit and implicit cursors in oracle?
where are cookies actually stored on the hard disk? : Sql dba
