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 vote194 views1 answer
TSQL Find csv file in folder
SQL
0 vote142 views1 answer
Char vs varchar2 in sql
SQL
3 votes187 views1 answer
How to get yesterday date in sql
SQL
0 vote148 views1 answer
Oracle last connexion
SQL
0 vote171 views1 answer
Copy row from db to db mysql
SQL
0 vote135 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote161 views1 answer
What is default mysql database password in linux
SQL
0 vote164 views1 answer
Mysqldump: error:
SQL
0 vote153 views1 answer
Can you write relational algebra into sql queries
SQL
1 vote122 views1 answer
Oracle finding duplicate records
SQL