Querry mysql by 2 columns

SELECT * FROM tbl_customer 
    WHERE CustomerName LIKE '%".$search."%'
    OR Address LIKE '%".$search."%' 
    OR City LIKE '%".$search."%' 
    OR PostalCode LIKE '%".$search."%' 
    OR Country LIKE '%".$search."%'

Source: stackoverflow.com

Similar codes

0 vote229 views1 answer
Postgresql add not null and not empty constraint
SQL
4 votes235 views3 answers
Mysql update with join
SQL
2 votes201 views1 answer
Latest record in sql
SQL
0 vote235 views1 answer
Mariadb used space
SQL
6 votes630 views3 answers
Sql select last id
SQL
1 vote234 views1 answer
How to install mysql 8.0 windows service
SQL
3 votes241 views2 answers
Get current year sql
SQL
0 vote254 views1 answer
Left join vs inner join performance
SQL
6 votes190 views2 answers
Generate c# class from sql server table
SQL
0 vote219 views2 answers
Mysql get routine parameter list
SQL