Here are 5 steps to do this in HeidiSQL, I had to download it to do this, you're welcome, haha. If you cannot read the query I will put it below.
Step 1
Step 2
Step 3
Step 4
Step 5
Code:
/*Remember to change %XXXX% to your zone name!*/
SELECT * FROM zone WHERE short_name LIKE "%XXXX%";