ok, lets say i have a database that has rows with comma seperated cells in it. I need to see if any of the comma seperated cells contain a number. Is there a way to do that with a query rather then to grab the row, explode the cell and loop through it?
Depends on what database you are using! I know mysql support regular expression on the SELECT statement (REGEXP): SELECT FROM tbl WHERE col REGEXP ".,[0-9.]+,";
Or something like that, not quite sure that's right though... 🙂
perfect! thank you.
