[asterisk-users] MySQL cmd % pattern matching

[Jon Farmer]

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