Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Useful EE-Related SQL Snippets
SELECT concat( 'field_id_' , field_id , ' AS ' , field_name , ',' ) AS fieldget
FROM exp_channel_fields
WHERE group_id = 3
UNION
SELECT 'entry_id AS eid' AS fieldget
SELECT
CONCAT( 'ALTER TABLE exp_channel_data MODIFY COLUMN field_ft_' , field_id , ' VARCHAR(128);' )
FROM
exp_channel_fields;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.