Syntax error need help

Good Day everyone
Thank you for trying to help first of all.

My question is about;

Im trying to write and sql request which will execute the following
1. When user enters a certain terminal code then the sql returns the results for that terminal
2. When user enters terminal code with mask CN then the sql request returns all terminals who have CN at the beginning of that terminal

Im aware ill probably will need to use the CASE here

So far i got,

SELECT sm.terminalid as terminalcode,...

Syntax error need help

from MySQL https://ift.tt/2CJi1Ng
via IFTTT