Sql

Search

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."%'

Comment

PREVIOUS	NEXT

Code Example
Sql :: compare field sql server
Sql :: if role exists sql
Sql :: mysql autoincrement valor inicial
Sql :: subquery in mysql
Sql :: get comma separated values in mysql with group by
Sql :: sql server obtener nombre sin espacios en blanco
Sql :: postgres show table schema
Sql :: order by with where clause in mysql
Sql :: sql cte example
Sql :: how to show current database in mysql
Sql :: full-text index mysql
Sql :: oracle INTERVAL DAY to second to number
Sql :: oracle all columns
Sql :: microsoft sql server management studio uppercase shortcut
Sql :: insert or update cassandra
Sql :: codeigniter dbforge add index
Sql :: add column first position mysql
Sql :: mysql workbench change default value
Sql :: create procedure
Sql :: mysql in clausule string array
Sql :: what is postgresql
Sql :: connectionString
Sql :: remove duplicates mysql
Sql :: how to use join with 3 tables in sql server
Sql :: not null sql
Sql :: sql queries practice
Sql :: create a table
Sql :: CREATE table schema using select
Sql :: sql decimal with 2 places
Sql :: C# mysql update statement set value to null

Search

SQL

querry mysql by 2 columns

ADD CONTENT