Interested to Buy Any Domain ? << Click Here >> for more details...
What are all the difference between Like and Contains ?
- 2 Answers
- 10892 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 rownum and rowid?
What is lexical units in pl sql?
What does fetching a cursor do?
Can I join the same table twice?
what is offset-fetch filter in tsql? : Transact sql
What are all the different types of indexes?
What type of database is cloud sql?
What is scope of pl sql developer in future?
What is rowtype?
What plvcmt and plvrb does in pl/sql?
Explain what is a subquery ?
What is the use of procedures?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
How do you take the union of two tables in sql?
Explain alias in sql?
