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

3 votes276 views2 answers
How to delete git repo locally
SQL
0 vote259 views1 answer
Postgresql find missing id
SQL
0 vote254 views2 answers
Plan d'exécution requete oracle autotracer
SQL
16 votes305 views3 answers
T-SQL Add Column
SQL
3 votes246 views1 answer
Pl sql check if variable is empty
SQL
0 vote252 views1 answer
Login failed for login due to trigger execution
SQL
0 vote271 views1 answer
Contraint default SQL
SQL
10 votes286 views2 answers
What is database
SQL
0 vote295 views1 answer
Sql constarint
SQL
6 votes296 views4 answers
Mysql get random row
SQL