One question, should I return values from a second string that do not contain 1 and 7. For example: 256-08-36
or 369-68-41
(both middle numbers do not have 1 and 7)
I have this query:
SELECT autor_id
FROM autores
WHERE autor_id LIKE '[7-9]____[^1,7]%'
The number 7 keeps appearing, the 1 is not shown. What am I doing wrong?
You have an extra underline.
In the middle series you have neither one nor seven in the characters in the positions between the hyphens.
That could be a solution
To check the central series, you can use the following pattern:
The brackets
[]
specify a single character, in this case we are denying that the first and second characters are 1 or 7.