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,