Answers for "sql select column names starting with"

sql select column names starting with

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_NAME`='producten' AND `COLUMN_NAME` LIKE 'pweb%'
AND DATA_TYPE = 'int'

Posted by: Guest on January-12-2022

Code answers related to "sql select column names starting with"