DB Query replaces %s inside LIKE operator
You just need to escape % signs with another % sign in a Drupal db query:

db_query("SELECT * FROM {foo} WHERE bar LIKE '%%supply%%' LIMIT %d,%d", 0, 10);


If you wanted to use a placeholder it would be like so:

db_query("SELECT * FROM {foo} WHERE bar LIKE '%%%s%%' LIMIT %d,%d", 'supply', 0, 10);