in reply to Re^2: SQL LIKE and Binding Variables
in thread SQL LIKE and Binding Variables

Oracle, PostgreSQL, MySQL, SQLite, and even MS SQL Server have an ESCAPE keyword for this purpose. I'm too lazy today to find out if it is an official SQL standard or just one implementation copying the other one. But five very different databases agreeing on the same syntax for the same feature is simply too good to be just luck.

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

In Section Seekers of Perl Wisdom