Select ONLY the text that BEGINS with a given letter

Question

User1504639868 posted

Let’s say I have the following data in a text file

Z

 

ZENworks Asset Management - Client Apps

 

Microsoft Internationalized Domain Names Mitigation APIs

 

FileZilla Client 3.6.0.2 --Version: 3.6.0.2

 

7-Zip 9.20

 

hpzTLBXFX --Version: 002.002.00170

 

Mozilla Firefox 23.0.1 (x86 en-GB) --Version: 23.0.1

 

hpzTLBXFX --Version: 004.014.00150

 

ZyXEL G-302 v3  Utility --Version: 3.00

 

EasyZip

 

 

What would be the correct Log Parser query to select ONLY THE TEXT BEGINNING WITH THE LETTER Z

Would some one kindly provide me with an example?

Answer 1

User56485982 posted

SELECT * FROM table WHERE name LIKE '[Z]%'