vendredi 27 octobre 2017

PostgreSQL Query Fields with Specific String Format

I have a PostgreSQL database, inside one of the tables we a string field that is formatted something like the following examples...

Fall 2017 MAT1277 OO4

Yet other fields may be something like this...

Fall 2017 Example Course For Name

I need to perform a query that ONLY searches for courses that are formatted like the first example (Fall 2017 MAT1277 OO4) but here's the catch. The following will remain the same yet the others will be different for each course.

Fall 2017 XXXXXXX OOX - Where X indicates the characters that will be different. Anyway to perform a query that will only return the course name's that are formatted in this fashion?

Thank You!

Aucun commentaire:

Enregistrer un commentaire