mysql - 给MYSQL错误子查询返回多行

Question

 SELECT j. * , w. * 
    FROM tbljobseeker j
    INNER  JOIN tblworkexp w ON j.id = w.userid
    WHERE (
     w.company_name LIKE  '%xoriant%'
    OR w.company_name LIKE  '%XORIANT%'
    OR w.company_name LIKE  '%Xoriant%'
    OR w.company_name LIKE  '%Xoriant%')
     AND (
    w.tomonth !=  'till'
    )
   AND (
   w.fromyear = ( 
   SELECT w.fromyear
    FROM tblworkexp
     WHERE w.tomonth !=  'till'
    ORDER  BY w.fromyear DESC 
     LIMIT 1 , 10 ) 
    )
     ORDER  BY STR_TO_DATE( j.lastModified,  '%e-%M-%Y'  )  DESC , id DESC

请帮忙

Answer 1

您正在分配多个值，而预期只有一个值。

这会起作用，因为它现在会检查一个范围:

SELECT j. * , w. * 
    FROM tbljobseeker j
    INNER  JOIN tblworkexp w ON j.id = w.userid
    WHERE (
     w.company_name LIKE  '%xoriant%'
    OR w.company_name LIKE  '%XORIANT%'
    OR w.company_name LIKE  '%Xoriant%'
    OR w.company_name LIKE  '%Xoriant%')
     AND (
    w.tomonth !=  'till'
    )
   AND (
   w.fromyear in ( 
   SELECT w.fromyear
    FROM tblworkexp
     WHERE w.tomonth !=  'till'
    ORDER  BY w.fromyear DESC 
     LIMIT 1 , 10 ) 
    )
     ORDER  BY STR_TO_DATE( j.lastModified,  '%e-%M-%Y'  )  DESC , id DESC