Newbie question: Show employee names without 'R'. Thank you all for your help!

henailina

As the title, I checked a lot of character functions such as substr but they are not flexible enough to be arbitrary string length. I hope the experts can answer, thank you!

henailina

Do you like it first? Does anyone help?

abc8845052

select * from employees where name not like'%r%'

henailina

Haha, I actually regret such a simple question after I post it. I always think about character functions and the like, and forget even the most basic fuzzy queries. Anyway, thanks. Master!