Sql

CONCAT(column_name1, column_name2) AS column_name;

WHERE CONCAT(customers.first_name, ' ', customers.last_name) LIKE '%John Smith%'

PREVIOUS	NEXT

Code Example
Sql :: sql server select where date
Sql :: create a unqie constraint mysql
Sql :: sql auto timestamp
Sql :: mysql backup skip table
Sql :: org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
Sql :: sQL query to get all table records count from a database
Sql :: get two decimal places in sql server
Sql :: mysql alter decimal precision
Sql :: sql like query
Sql :: date in where on datetime column clause mysql
Sql :: psql show columns of table
Sql :: postgresql substring
Sql :: delete role postgres
Sql :: oracle undo usage by session
Sql :: ORA-00903
Sql :: SQL: merging multiple row data in string
Sql :: replace all numbers in mysql
Sql :: contains word in sql
Sql :: select table column name in sql
Sql :: docker run postgres locally
Sql :: SQL rounding numbers
Sql :: postgresql create schema in specific database
Sql :: select all tables sql
Sql :: mysql change auto_increment start value
Sql :: change role postgres
Sql :: mysql insert value date
Sql :: add primary key with auto increment sql server
Sql :: sql drop default
Sql :: sqlite truncate tables command
Sql :: like in mysql