Answers for "check if column exists in table sql"

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'

Posted by: Guest on March-11-2021

sql value exists in column

SELECT * FROM table_name WHERE col_name = my_value;
SELECT * FROM table_name WHERE col_name LIKE '%my_value%';

Posted by: Guest on July-08-2021

Code answers related to "check if column exists in table sql"