'Is there a way to filter string by various criteria?

I'm trying to pull a list of product names. In MySQL, is there a way to filter string values in the below criteria under the Where clause?

  • Product name should have more than 1 word
  • Product name cannot just be a number

As a reference, I'm working with an extremely simple query:

FROM organization                       
JOIN product on o.id = p.id                         
JOIN customer on c.id = o.id
mysql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions