Useful EE-Related SQL Snippets

-- Useful EE-Related SQL Snippets

1. Retrieve all fields in group, plus entry_id, preformatted to paste into a query
2. Get code to alter field_ft_## to VARCHAR(128)

Get field names in correct format for later query .sql

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

Get sql to alter all field_ft_## columns to varchar .sql

SELECT 
    CONCAT( 'ALTER TABLE exp_channel_data MODIFY COLUMN field_ft_' , field_id , ' VARCHAR(128);' )
FROM 
    exp_channel_fields;