[asterisk-users] MySQL cmd % pattern matching

[Garth van Sittert]

Hi Jon

No luck - it works with the quotes and no % sign but as soon as I add 
the % it doesn't work.

Garth



Jon Farmer wrote:
> Try enclosing in single quotes. ie. 
>  SELECT name from contacts where tel like '%${number}'
>
>
>
> Jon Farmer
> Telford, Shropshire, UK
>
> ----- Original Message ----
> From: Garth van Sittert <garth at bitco.co.za>
> To: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users at lists.digium.com>
> Sent: Monday, 4 December, 2006 12:38:07 PM
> Subject: [asterisk-users] MySQL cmd % pattern matching
>
> 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
>
>
>
>
>
> 	
> 	
> 		
> ___________________________________________________________ 
> All new Yahoo! Mail "The new Interface is stunning in its simplicity and ease of use." - PC Magazine 
> http://uk.docs.yahoo.com/nowyoucan.html
> _______________________________________________
> --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
>