Pattern Matching : Patterns « Regular Expression « SQL / MySQL





Pattern Matching

    
/*
mysql> SELECT ExamID,SustainedOn,Comments FROM Exam
    -> WHERE Comments LIKE '%Java%';
+--------+-------------+-----------------+
| ExamID | SustainedOn | Comments        |
+--------+-------------+-----------------+
|      1 | 2003-03-12  | Java Test       |
|      3 | 2005-03-11  | JavaScript Test |
+--------+-------------+-----------------+
2 rows in set (0.00 sec)


*/
/* Prepare the data */ 
DROP TABLE Exam;

CREATE TABLE Exam (
   ExamID      INT NOT NULL PRIMARY KEY,
   SustainedOn DATE,
   Comments    VARCHAR(255)

)TYPE = InnoDB;


/* Insert data for testing */ 
INSERT INTO Exam (ExamID,SustainedOn,Comments) VALUES (1,'2003-03-12','Java Test');
INSERT INTO Exam (ExamID,SustainedOn,Comments) VALUES (2,'2004-03-13','C# test');
INSERT INTO Exam (ExamID,SustainedOn,Comments) VALUES (3,'2005-03-11','JavaScript Test');
  
/* Real command */
SELECT ExamID,SustainedOn,Comments FROM Exam 
WHERE Comments LIKE '%Java%';

           
         
    
    
    
  










Related examples in the same category

1.Pattern match: string has 5 characters
2.Pattern match: letter repeats
3.Pattern in Where clause
4.Using Pattern Matching
5.Show records where the name matches a search pattern
6.Matching Pattern Metacharacters Literally
7.To match a literal instance of a SQL pattern metacharacter, precede it with a backslash:
8.To make a pattern match case sensitive, use a binary string for either operand
9.Pattern Matching with Regular Expressions