Re: Retreiving specific content in a Database table field

[Rick James]

WHERE gps RLIKE '[a-z]' -- look for a letter
WHERE gps NOT RLIKE '^[0-9]+$' -- anything other than digits (also catches empty string)
WHERE gps NOT RLIKE '^[0-9.]+$' -- anything other than digits or decimal
WHERE gps NOT RLIKE '^[-+0-9.]+$' -- anything other than digits, decimal, sign (note: "-" must be first)
WHERE gps NOT RLIKE '^[0-9]{7}$' -- anything other than exactly 7 digits