Possible Duplicate:
Print the query which is built using db_select()

How can I remove

and table prefix from database query
debug function.

  • Put the actual data into the placeholder. When I printed the queries, it gave me the table name in brackets: {table}. What is the prefix for you? Plz, provide the query, you are debugging.
    – user4035
    Jan 15, 2013 at 12:45
  • it's ok, but what I should do to replace the tables prefix with {} dynamically. so can I print it directly to Navicat or PHPMyadmin for example directly. Jan 16, 2013 at 6:27
  • did you try dpq function from devel module: api.drupal.org/api/devel/devel.module/function/dpq/7? Seems pretty good.
    – user4035
    Jan 16, 2013 at 12:39
  • yes I did, but unfortunately, it doesn't remove it. In drupal 6 there is a function called db_prefix_tables() but I can't find it in drupal 7! Mar 11, 2013 at 11:31


Browse other questions tagged or ask your own question.