How to use LIKE in db_query drupal

    You can user LIKE in db_query in drupal using following way:
    Generally you use %s in db_query in drupal but with like you have to use %%s So a demo query with like looks like this in drupal:
    <?php
    db_query
    ('select name from {my_table} where name like "%%%s%"', $name);

    ?>
    0