I have a table in which one column stores some alphanumeric values
I am trying to get a count of records in my database that have a particular format (and those that don't)
The column has values in the following formats
where AA are alpha characters and xxxx are numeric characters
I tried the following to get the count of ones formated like AAxxxxxxxxxAAAAA
I also tried replacing the REGEXP with like
but still I am getting 0 all the time
SELECT count( * )
Any help would be appretiated
You are on the right track with the RegExp here. But you must remove the dashes. They will be interpreted literally, and based on what you describe your data does not contain any dashes.
This topic is now closed. New replies are no longer allowed.