dongxiong5546 2015-07-11 18:26
浏览 451

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_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_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.


    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥15 怎么在matlab中输出显示泵的流量-扬程和管路损失与流量均在一个表格里
  • ¥15 matlab学期例题代码答疑
  • ¥50 Hadoop:好友推荐
  • ¥15 在线手电筒追加按钮JS
  • ¥15 调用函数时,无关变量的改变引起函数值的改变
  • ¥15 xy坐标转化为经纬度坐标
  • ¥15 一般三角模糊数的上界值和下届值取中值的多少比较合理?
  • ¥15 cuda安装使用问题
  • ¥15 关于#python#的问题,请各位专家解答!
  • ¥20 Hbase启动失败,无法启动HMaster