SQL: Using where clause with not like operator and escape character
SQL Wildcard & Special Operator: Exercise-16 with Solution
Write a SQL statement to find those rows from the table testtable which contain the string ( _/ ) in its column 'col1'.
Sample table: testtable
SELECT * FROM testtable WHERE col1 LIKE '%/_//%' ESCAPE '/';
Output of the Query:
col1 A001/DJ-402\44_/100/2015 A001_\DJ-402\44_/100/2015
Pictorial presentation :
Contribute your code and comments through Disqus.
Previous: Write a SQL statement to find those rows from the table testtable which does not contain the escape character ( / ) in its column 'col1'.
Next: Write a SQL statement to find those rows from the table testtable which does not contain the string ( _/ ) in its column 'col1'.
What is the difficulty level of this exercise?
- New Content published on w3resource :
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework