I'm trying to write a query to show the rows containing a code that begins with 11-digit number followed by -1
or -2
then _DataSheet
or _RoHS
Examples
02704198976-1_DataSheet
03448106681-1_RoHS
Query
SELECT m.PK, m.code
FROM medias m
WHERE m.code LIKE CONCAT(REPLICATE('[0-9]', 11),'-[1-2]_(DataSheet|RoHS)%')
Results
0 rows returned
If I change the WHERE
clause, then it shows too may results.
Query
SELECT m.PK, m.code
FROM medias m
WHERE m.code LIKE CONCAT(REPLICATE('[0-9]', 11),'-[1-2]_%')
Results
02704198976-1_DataSheet
03448100857-1_SDS
03448106681-1_RoHS
%
in the end required or not?