Re^2: SQL LIKE and Binding Variables

(I hope I remember correctly that % is escaped as %% in LIKE queries).

Um, nope. Perhaps you're confusing SQL LIKE with (s)printf?

Comment on Re^2: SQL LIKE and Binding Variables

Replies are listed 'Best First'.
Re^3: SQL LIKE and Binding Variables by afoken (Chancellor) on Nov 04, 2009 at 20:03 UTC
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". ;-)	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: SQL LIKE and Binding Variables
by afoken (Chancellor) on Nov 04, 2009 at 20:03 UTC

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". ;-)

[reply]
[d/l]