dsgixl5195 2015-12-28 14:19
浏览 39
已采纳

所有字段的类似查询数组

I have an array like array('first','12'). So i need to select the table using like condition. which fields have those values.

Example Query:

SELECT * FROM `class` WHERE name LIKE '%first%' 
OR father_name LIKE '%first%'
OR age LIKE '%first%'
OR name LIKE '%12%'
OR father_name LIKE '%12%'
OR age LIKE '%12%'

I need to find all the fields with or condition. Is this good or have any other options to find an array of values in all fields.

Thanks,

  • 写回答

1条回答 默认 最新

  • dongmu2517 2015-12-28 14:41
    关注

    You can shorten the query using REGEXP, like this:

    SELECT * FROM class 
    WHERE name REGEXP 'first|12' 
    OR father_name REGEXP 'first|12' 
    OR age REGEXP 'first|12';
    

    Here's the reference:

    And like you said, if you have an array like this,

    $arr = array('first',12);
    

    Then your query should be like this:

    $query = "SELECT * FROM class WHERE name REGEXP '" . $arr[0] . "|" . $arr[1] . "' OR father_name REGEXP '" . $arr[0] . "|" . $arr[1] . "' OR age REGEXP '" . $arr[0] . "|" . $arr[1] . "'";
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?