So the mySQL statement says "find an ampersand that has a space on either side"?
<!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 15, 2005 8:26 AM To: CF-Talk Subject: Re: searching for a '%' in an sql like statement... Here it is... for anyone else following this thread.. SQL - Predicates Escaping Characters Say you want to find a percent character(%) in your database, or all rows associated with one. SQL Server and Oracle, require an additional statement over MySQL. With Oracle and SQL Server, you must specify the character used to escape. Here's code example. SQL Code: Oracle/SQL Server SELECT * FROM employees WHERE Lastname LIKE '%\%%' ESCAPE '\'; MySQL SELECT * FROM employees WHERE Lastname LIKE '%\%%' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224187 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
