我有一个列,有不同的阶段,如小学,中学,认为小学,认为中学。我想再开一个专栏,用公式来考虑小学,把小学当作“小学”,把中学和中学当作“中学”。下面是我试图用公式实现的例子
Column Phase New Column should show data of column phase as
Deem Primary Primary
Primary Primary
Primary Primary
Deem Primary Primary
我当前的查询:
SELECT SCHOOL_NAME, TOWN, POSTCODE, COUNTRY, COUNTY, id FROM schools
WHERE MATCH(LA_NAME, SCHOOL_NAME, STREET, LOCALITY, ADDRESS3, TOWN, COUNTY)
AGAINST ("southwark") AND COUNTRY = 'gb' limit 0,5;
正在返回(删除了一些数据以保持正常):
Southwark Park School
The Cathedral School of St Sav