select column names that start with x [duplicate]

Question

Im trying to select all column names from a mysql table that start with pweb and then have an integer.

This works for all column names:

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_NAME`='producten';

But this does not work unfortunately, how can I make this happen?

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_NAME`='producten' AND `COLUMN_NAME` LIKE `pweb`;

Thanks!

Answer 1

Try this

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

Answer 2

you have to add the % after pweb.

so the sql statement select all column_name which begins with pweb**

Note: ** means other caracteres

SELECT COLUMN_NAME 
FROM INFORMATION_SCHEMA, COLUMNS 
WHERE TABLE_NAME='producten' AND COLUMN_NAME LIKE 'pweb%';

Hope this help you