Regular Expressions (REGEX)

You can use regular expressions as a data type in a predicate (the WHERE clause). This is useful if you want to compare a value with the regular expression to check for a match.

You can try the following examples against your own data in the GoToAssist search field, or against fictitious data in the Query Sandbox:

Example 1

Query: Find all instances of Microsoft Office.

SELECT name 
FROM /network/device/wmi/win32_product 
WHERE name = ?Microsoft.*Office?

Results: Depending on the database, the results look similar to this:

row
   name Microsoft Office Visio Professional 2003
row
   name Microsoft Office Small Business Edition 2003
row
   name Microsoft Office Excel MUI (English) 2007 
   . . .

Example 2

Query: Find all IP addresses starting with 10.10.

SELECT ip_address 
FROM /network/device/interface/inet 
WHERE ip_address = ?10\.10\.\d+\.\d+?

Results: Depending on the database, the results look similar to this:

row
   ip_address 10.10.10.102
row
   ip_address 10.10.10.7
row
   ip_address 10.10.10.6 
   . . .

Example 3

Query: Find all IP addresses starting with something similar to 10.10.

SELECT ip_address 
FROM /network/device/interface/inet 
WHERE ip_address like ?10\.10\.\d+\.\d+?

Results: Depending on the database, the results look similar to this:

row
   ip_address 10.10.10.102
row
   ip_address 10.10.10.7
row
   ip_address 10.10.10.6 
   . . . 

Related topics

• Expressions
• Functions
• Operators
• Read about PQL

| Views: 1143 | Last Updated: Thu, May 09 2013 2:28 PM

Is this article helpful?