RsD0p9BK
6/9/2015 - 12:14 PM
regexp.sql
-- select rows where column is an integer value
SELECT * FROM mytable WHERE mycolumn REGEXP '^[0-9]+$'
-- http://stackoverflow.com/questions/10347033/how-to-select-all-rows-where-mycolumn-is-an-integer-value-- select rows where column is an integer value
SELECT * FROM mytable WHERE mycolumn REGEXP '^[0-9]+$'
-- http://stackoverflow.com/questions/10347033/how-to-select-all-rows-where-mycolumn-is-an-integer-value