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

_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to