[asterisk-users] MySQL cmd % pattern matching

[Garth van Sittert]

Hi All

Does anyone know how to use the MySQL cmd in Asterisk with LIKE and % in 
the query?

I have:

    exten => s,5,Set(query=SELECT name from contacts where tel like 
%${number})
    exten => s,6,MySQL(Connect connid hostname username password dbname)
    exten => s,7,MySQL(Query resultid ${connid} ${query})

But there seems to be a problem with the % sign and I don't know how to 
hash it out.
It works without the % sign.

Thanks

Kind Regards
Garth