时间戳

首页 > 解决方案 > SQL 查询建议

mysql - SQL 查询建议

问题描述

我写了这个查询。它给了我一个错误，它与转义引号有关。如果有人可以帮助我，那就太好了。

我想做的事情：

如果网站栏有数据则显示公司名称作为链接，如果网站栏没有数据，则正常显示公司名称

SELECT CONCAT(
    CASE WHEN qpiy_test_data_2.`Website` != '' THEN '<a href="http://',wpiy_test_data_2.`Website`,'" target="_blank">'
    ,wpiy_test_data_2.`Company_Name`,
    CASE WHEN qpiy_test_data_2.`Website` != '' THEN '</a>') AS Company_Name, 
       wpiy_test_data_2.`Input_Product_Name`,
       wpiy_test_data_2.`Brand_Name`,
       wpiy_test_data_2.`Usage_Category`,
       wpiy_test_data_2.`Usage_Annotation`,
       wpiy_test_data_2.`Standard`,
       wpiy_test_data_2.`City`,
       wpiy_test_data_2.`Province`,
       wpiy_test_data_2.`Phone`,
       wpiy_test_data_2.`Email`,
       wpiy_test_data_2.`Website`
FROM wpiy_test_data_2

错误它给了我：

SELECT CONCAT(
    CASE WHEN qpiy_test_data_2.`Website` != '' THEN '<a href="http://',wpiy_test_data_2.`Website`,'" target="_blank">'
    ,wpiy_test_data_2.`Company_Name`,
    CASE WHEN qpiy_test_data_2.`Website` != '' THEN '</a>') AS Company_Name, 
       wpiy_test_data_2.`Input_Product_Name`,
       wpiy_test_data_2.`Brand_Name`,
       wpiy_test_data_2.`Usage_Category`,
       wpiy_test_data_2.`Usage_Annotation`,
       wpiy_test_data_2.`Standard`,
       wpiy_test_data_2.`City`,
       wpiy_test_data_2.`Province`,
       wpiy_test_data_2.`Phone`,
       wpiy_test_data_2.`Email`,
       wpiy_test_data_2.`Website`
FROM wpiy_test_data_2 LIMIT 0, 25
**MySQL said: Documentation**

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'wpiy_test_data_2.`Website`,'" target="_blank">'
    ,wpiy_test_data_2.`Company_' at line 2

标签： mysqlsql

解决方案

对我有用的最终查询。

SELECT 
( CASE 
WHEN wpiy_test_data_2.`Website` != '' THEN CONCAT('<a href="http://',wpiy_test_data_2.`Website`,'" target="_blank">' ,wpiy_test_data_2.`Company_Name`,'</a>') 
ELSE wpiy_test_data_2.`Company_Name` end) AS Company_Name,
wpiy_test_data_2.`Company_Name` AS Actual_Name,
wpiy_test_data_2.`Input_Product_Name`,
wpiy_test_data_2.`Brand_Name`,
wpiy_test_data_2.`Usage_Category`,
wpiy_test_data_2.`Usage_Annotation`,
wpiy_test_data_2.`Standard`,
wpiy_test_data_2.`City`,
wpiy_test_data_2.`Province`,
wpiy_test_data_2.`Phone`,
wpiy_test_data_2.`Email`,
wpiy_test_data_2.`Website`
FROM 
wpiy_test_data_2

推荐阅读