Good time of day.
There is a text input where user enters the address.
<input type="text" name="address" placeholder="Street, District, territory">
How to write the query so that the values in this field were searched for in several columns in the database table ?
$query = "SELECT * FROM `objects` WHERE `bid_type`='$bid_type' AND `object_type`='$object_type' AND `address` LIKE '%$address%' AND `okrug` LIKE '%$address%'";
But constantly comes up false in the result.
How to write a query that value in input was sought in three-four columns and output all found