I inherited a site with a zillion channels, and every channel has "Automatically Convert URLs to Links?" set to "yes".

Is there a query I can use to update the preferences for all of these channels to "no" at the same time?

EE 2.5.2

1 Answer 1


The following should work:

UPDATE exp_channels SET channel_auto_link_urls = 'n';

Backup your DB first though! Always better to be safe.


My answer assumes that you know about the Database Query Form. It's located in Tools » Data » SQL Manager » Database Query Form.

Further Update:

Removed backtick quotes from around table / column names for strange instances where that might cause an SQL error. :-)

  • Could you edit your answer to remove the quotes around the table names? It was causing a SQL error for me.
    – kmgdev
    Feb 15, 2013 at 19:10
  • @kgrote - Done! Feb 16, 2013 at 0:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.