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?
ExpressionEngine® Answers is a question and answer site for administrators, end users, developers and designers for ExpressionEngine® CMS. It only takes a minute to sign up.Sign up to join this community
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.
Removed backtick quotes from around table / column names for strange instances where that might cause an SQL error. :-)