How can I test if a column exists in a table using an SQL statement

Try this :

SELECT column_name 
FROM information_schema.columns 
WHERE table_name="your_table" and column_name="your_column";