列等于mysql中的某些内容

I am interested in how to write mysql query like this => if some column includes multiple exactly same data, how to check if that column value equal to something . for example I have table with column named "local" and I'm checking like that =>I am interested in how to write mysql query lik