Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Use LIKE Conditions
How To Use LIKE Conditions? - Oracle DBA FAQ - Understanding SQL Basics
✍: FYIcenter.com
LIKE condition is also called pattern patch. There 3 main rules on using LIKE condition:
The following script provides you some good pattern matching examples:
SELECT CASE WHEN 'FYICenter.com' LIKE '%Center%' THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE SELECT CASE WHEN 'FYICenter.com' LIKE '%CENTER%' THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; -- Case sensitive by default FALSE SELECT CASE WHEN 'FYICenter.com' LIKE '%Center_com' THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE SELECT CASE WHEN '100% correct' LIKE '100\% %' ESCAPE '\' THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE
2007-04-23, 4537👍, 0💬
Popular Posts:
How To Empty Your Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables If your recycle bi...
What's wrong with this initialization? char *p = malloc(10); My compiler is complaining about an ``i...
What will be printed as the result of the operation below: main() { int a=0; if (a==0) printf("Cisco...
What Happens If a Hyper Link Points to a Music File? - XHTML 1.0 Tutorials - Understanding Hyper Lin...
How To Get the Minimum or Maximum Value of an Array? - PHP Script Tips - PHP Built-in Functions for ...