By biosv on

Why is there extra %%?
Wouldn't it just work with LIKE LOWER('%s') in SQL?

⋅ Categories: Drupal 6.x

Comments

Drave Robber’s picture

Drave Robber commented

%% here stands for %, which in turn is a wildcard for any number (including zero) of characters. See http://dev.mysql.com/doc/refman/5.1/en/string-comparison-functions.html#...

So, db_query("LIKE LOWER('%%%s%%')", 'foo') would yield LIKE LOWER('%foo%')

biosv’s picture

biosv commented

Got it. Thanks.

nevets’s picture

nevets commented

LOWER('%s') does not work because the percent is special to drupal and mysql, so to get a % through to mysql you need %% (an escaped %), the %s being handled by Drupal