Hi everybody. I really have tried looking around and even learning regular expressions to do this, but I really am helpless with this stuff.  I want to search a string that is concatenated with | in a mysql database. However, the fields may contain No Smoking or Smoking. By searching for Smoking, I also get Smoking, as it finds the string ...