mysql - SQL搜索类似，并按空格切割结果

Question

假设我有下表:

ID      City
1        New York
2        London
3        Yorkshire
4        West Yorkshire
5        North Yorkshire
6        Downyork

我如何从这个表 (id 1,3,4,5) 中获取每一行，其中包含一个以 York 开头的单词？

We can safely assume that each and every word is separated by a single space

如果我这样做

 SELECT * FROM table WHERE City LIKE '%York%'

id 为 6 的行也被返回。

Answer 1

SELECT * FROM table WHERE City LIKE '% York%' OR City LIKE 'York%'