I want to get all the lines without Russian letters in a certain field - I make a query: SELECT * FROM What's my mistake? How to print all lines without Russian letters?

  • I tried without a range or set (for example, '% a%') - it works. What problems can there be with a range / set? - Hertz
  • regex is not supported. This is a central problem. only sequences of characters. - Drakonoved
  • @Drakonoved Google - examples everywhere with []% _ ^ characters. 2sql.ru/novosti/sql-like Can you tell me an alternative solution, without regularizers? Or are you saying that, for example, [a-i]% is a sequence, and% [a-i]% is already regular, since the algorithm needs to go through the string several times to find a match? - Hertz
  • 2
    LIKE does not support the required type of templates. Use NOT REGEXP dev.mysql.com/doc/refman/5.7/en/regexp.html - Akina
  • one
    @Akina I thank SELECT * FROM dle_post WHERE full_story NOT REGEXP '[az]] works. - Hertz

0