From the following table, write a SQL query to find those rows where col1 contains the escape character underscore ( _ ). Return col1

برمجة سي كيو ال sql

2021-08-31
mhanasmh00489829403

From the following table, write a SQL query to find those rows where col1 contains the escape character underscore ( _ ). Return col1.

Sample table: testtable

col1
--------------------------
A001/DJ-402\44_/100/2015
A001_\DJ-402\44_/100/2015
A001_DJ-402-2014-2015
A002_DJ-401-2014-2015
A001/DJ_401
A001/DJ_402\44
A001/DJ_402\44\2015
A001/DJ-402%45\2015/200
A001/DJ_402\45\2015%100
A001/DJ_402%45\2015/300
A001/DJ-402\44

الأجوبة

SELECT *
FROM testtable
WHERE col1 LIKE '%/_%' ESCAPE '/';


Output of the Query:

col1
A001/DJ-402\44_/100/2015
A001_\DJ-402\44_/100/2015
A001_DJ-402-2014-2015
A002_DJ-401-2014-2015
A001/DJ_401
A001/DJ_402\44
A001/DJ_402\44\2015
A001/DJ_402\45\2015%100
A001/DJ_402%45\2015/300

سجل الدخول لتستطيع الإجابة

هل كان المحتوى مفيد؟

0 نعم

0 لا

أسئلة مشابهة

From the following table, write a SQL query to find those rows where col1 does not contain the escape character underscore ( _ )

From the following table, write a SQL query to find those rows where col1 contains the character percent ( % ). Return col1

From the following table, write a SQL query to find those rows where col1 contains the forward slash character ( / ). Return col1

From the following table, write a SQL query to find those rows where col1 contains the string ( _/ ). Return col1

القوائم الدراسية التي ينتمي لها السؤال

لايوجد قوائم حاليا

معلومات ذات صلة

تبحث عن مدرس اونلاين؟

ابحث عن مدرسك