dongxiong5546
2015-07-11 18:26
浏览 289
已采纳

SQL查询 - 如何从数组中获取值?

I've been using the following SQL query to output values from my WordPress user profiles.

$divisions = $wpdb->get_col("
    SELECT Distinct(c.meta_value) 
    FROM $wpdb->usermeta AS r  
    INNER JOIN $wpdb->usermeta AS y
      ON r.user_id = y.user_id
    INNER JOIN $wpdb->usermeta AS g
      ON r.user_id = g.user_id
    INNER JOIN $wpdb->usermeta AS re
      ON r.user_id = re.user_id
    INNER JOIN $wpdb->usermeta AS c
      ON r.user_id = c.user_id
    WHERE r.meta_value LIKE '%subscriber%'
    AND y.meta_key = 'CERTIFIED_DISPLAY'
    AND y.meta_value NOT LIKE 'no'
    AND g.meta_key = 'CERTIFIED_CATEGORY'
    AND g.meta_value = '$category'
    AND re.meta_key = 'dbem_region'
    AND re.meta_value = '$region'
    AND c.meta_key = 'dbem_school_division'
    ORDER BY c.meta_value ASC
    ");

It worked great until I had to change one of the meta keys ('CERTIFIED_CATEGORY') to an array. That particular field used to be a select box with a single value, and then I changed it to a checkbox list which is an array of values. This is the part of the query I now need to fix:

AND g.meta_key = 'CERTIFIED_CATEGORY'
AND g.meta_value = '$category'

$category is one of the values in the array. I thought I could just change the '=' to 'LIKE', but it didn't work:

AND g.meta_key = 'CERTIFIED_CATEGORY'
AND g.meta_value LIKE '$category'

I also tried 'IN', but no luck. How can I do this?

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • duan0403788996 2015-07-13 18:45
    已采纳

    It seems all I needed to do was change this line:

    AND g.meta_value = '$category'
    

    to this:

    AND g.meta_value LIKE '%$category%'
    

    I had already tried using LIKE, but I didn't use the % signs around the variable. Apparently the % was necessary, because now it works. Wish I knew more to explain why.

    Thanks!

    已采纳该答案
    打赏 评论
  • dsms21398 2015-07-11 18:35

    I think you can use the mysql_fetch_array command for this.

    Check the following link : PHP.NET

    In the above link there is also an example.Hope this helps.

    打赏 评论

相关推荐 更多相似问题