mysql - MySQL :how to use Wildcard in Subquery?

Question

例子:

SELECT country 
FROM data
WHERE city LIKE 
(SELECT LEFT ('jakartada',7));

它工作得很好，但如果我给定界符值:4，我必须给通配符像这样 ---> "%string%"，我可以在查询中提供通配符的地方？

Answer 1

使用 LIKE，您可以在模式中使用以下两个通配符。

Character   Description
%           Matches any number of characters, even zero characters
_           Matches exactly one character
\%          Matches one “%” character
\_          Matches one “_” character

这个查询对您有帮助吗？

SELECT country 
FROM data
WHERE city LIKE CONCAT ('%', (SELECT LEFT ('jakartada',7)), '%');