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 vote124 views1 answer
How to find username and password in oracle 18c
SQL
0 vote124 views1 answer
How to make case insensitive in sql
SQL
0 vote126 views1 answer
Sql select maximum column with other columns returned
SQL
23 votes129 views5 answers
Sql substring
SQL
2 votes141 views4 answers
Sql query interview questions
SQL
1 vote121 views1 answer
Oracle add proxy
SQL
0 vote145 views2 answers
Php convert dbf to mysql
SQL
6 votes121 views1 answer
Wordpress change user password sql
SQL
22 votes125 views3 answers
Join three tables sql
SQL
0 vote145 views2 answers
Mysql dump structure only
SQL