CODEWITHSUNDEEP
phpmysqlarrays
Srihari
Srihari

Reputation: 200

array of like query for all fields

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,

Upvotes: 0

Views: 87

Answers (1)

Rajdeep Paul
Rajdeep Paul

Reputation: 16963

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] . "'";

Upvotes: 1

Related Questions