sql - SQL中如何使用 'like'运算符？

Question

我想从 C_Table 中选择 Name='John' 并使用 like 运算符。例如，

select Name from C_Table where Name='John' AND where Details like %Boy%

我该怎么做？

(Table name is C_Table)
-----------------------------------------------
Name   |  P_No  |  C_No   |  Details          |
-----------------------------------------------
John   |  001   |  001    |  Good Boy         |
John   |  002   |  002    |  Naughty Boy      |
John   |  003   |  003    |  Very Bad Boy     |
Mary   |  004   |  004    |  Beautiful Girl   |
Mary   |  005   |  005    |  Pretty Girl      |
Mary   |  006   |  005    |  Gorgeous         |
-----------------------------------------------

Answer 1

你几乎成功了:

select name from table where name="John" and details like '%Boy%';