mysql - 有没有办法获得各种 REGEXP

Question

SELECT COUNT(nomes) AS Number of machines that use certain name FROM pos_systems
WHERE active=1
AND nomes IS NOT NULL
AND nomes <>''
AND nomes REGEXP 'akira'

我想知道是否有办法在同一查询中显示多个 REGEXP。

Answer 1

是的，您可以在下面的同一查询中使用多个 REGEXP

AND nomes REGEXP 'akira|secondvalue|thirdvalue'

Here is more info.