多个替换语句SQL?
问题描述:
我想带一个字段,搜索两个可能名称中的一个:cross
或memory
。取决于它是哪一个,将其替换为其对应的img。多个替换语句SQL?
我当前的代码(即作品)如下:
SELECT REPLACE(column_name,'cross','<img src=\"crossimg.png\" />') AS 'column_name'
FROM my_table;
我希望它是这样的:
SELECT REPLACE(column_name, if == 'cross' then img1, elseif == 'memory' then img2) AS 'column_name'
FROM my_table;
答
你可能正在寻找一个case语句:
SELECT case when column_name = 'cross' then img1
when column_name='memory' then img2
else column_name end as column_name from my_table;
答
我想通了,我结束了:
$sql = "SELECT REPLACE(REPLACE(column_name,'second','<img src=\"secondimg.png\" />'),'first','<img src=\"firstimg.png\" />') AS column_name from my_table;
if“what”== cross? column_name? –
您可以添加数据模型来澄清问题吗? –