我正在从中等文本列(数据(运行类似的语句,试图提取某些数据并替换为文本;
Select
CASE WHEN data like '%CPCCCA2002B - Use carpentry tools and equipment:["Workplace Based Training With Employer"]%' THEN 'Workplace' else 0 end as Option
FROM formz.user z
但似乎查询不会寻找任何过去的"设备" 我将非常感谢对此的一些帮助。
如果上面给出的是您的真实示例数据,那么在将backtick
放在别名上之后,而它被认为是一个keyword
CREATE TABLE testing(content VARCHAR(1000))
INSERT INTO testing VALUES
('Another things CPCCCA2002B - Use carpentry tools and equipment:["Workplace Based Training With Employer"]testing')
SELECT
CASE WHEN content
LIKE '%CPCCCA2002B - Use carpentry tools and equipment:["Workplace Based Training With Employer"]%'
THEN 'Workplace' ELSE 0 END AS `Option`
FROM testing z
如果它由于[
而出现问题,请在它之前使用任何特殊字符,例如*[
然后使用以下语法
CASE WHEN content LIKE 'sfsdf*[dsfad' ESCAPE '*' THEN 'Workplace' ELSE '' END
注意:当我尝试时,我没有发现第二个问题,但如果这是问题所在,那么您可以使用上述语法摆脱它,但使用永远不会出现在您的真实内容中的字符。
输出:
Option
---------
Workplace