check if value exists in column sql code example
Example: sql check if column exists
* Using the below query, You can check whether the table1 has a column named "id"
SHOW COLUMNS FROM table1 LIKE 'id'
* Using the below query, You can check whether the table1 has a column named "id"
SHOW COLUMNS FROM table1 LIKE 'id'