SELECT * FROM tbl WHERE clm LIKE CONCAT('％'，<其他SQL查询LIMIT 1>，'％')-如何? [英] SELECT * FROM tbl WHERE clm LIKE CONCAT('%',<other sql query LIMIT 1>,'%') - HOW?

问题描述

1)这会找到狗(犬)的日本符号:

1) This finds the japanese sign for dog (犬):

SELECT japanese 
  FROM edict 
 WHERE english LIKE 'dog' 
 LIMIT 1;

2)这样会在其中找到所有带有"dog"(犬)符号的日语单词:

2) This finds all japanese words with the sign for 'dog' (犬) in it:

SELECT japanese 
  FROM edict 
 WHERE japanese LIKE '%犬%';

---

3)我无法将这两者合而为一，因为这行不通?！

---

3) I am having trouble combining those two into one, because this doesn't work?!

SELECT japanese 
FROM edict 
WHERE japanese
LIKE CONCAT('%',
    SELECT japanese FROM edict WHERE english LIKE 'dog' LIMIT 1,'%'
);

推荐答案

括号很重要，因此，请尝试以下操作:

Parenthesises are important, therefore, try this :

SELECT japanese
FROM edict
WHERE japanese LIKE CONCAT('%', 
                           (SELECT japanese FROM edict WHERE english LIKE 'dog' LIMIT 1), 
                           '%');

告诉我们您遇到了什么错误可能很好.

It might have been good to tell us what error you received, though.

这篇关于SELECT * FROM tbl WHERE clm LIKE CONCAT('％'，<其他SQL查询LIMIT 1>，'％')-如何?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！