Sql

SELECT CONCAT(first_name, ' ', last_name) AS 'Name', dept FROM users;

select * from table where concat_ws(' ',first_name,last_name) 
like '%$search_term%';

PREVIOUS	NEXT

Code Example
Sql :: how to create a table based on another table in mysql
Sql :: add primary key to database sql
Sql :: declare temp table in sql
Sql :: initcap in sql
Sql :: sql server order by nulls last
Sql :: sql alter column
Sql :: mysql join two tables
Sql :: datagrip exec
Sql :: how to get max from each department in sql
Sql :: mysql find max value row
Sql :: list foreign key oracle
Sql :: mysql server not running
Sql :: google cloud sql postgres url example
Sql :: select other columns with distinct
Sql :: fk in insert mysql
Sql :: SQL Server OPENJSON FROM table column
Sql :: how to update values in sql
Sql :: what is denormalization in sql
Sql :: insert data from one database table to another database table in postgresql using pgadmin
Sql :: delete insert record in sql server
Sql :: first mysql
Sql :: array aggre distinct postgres
Sql :: sql foreign key constraint
Sql :: hour must be between 1 and 12
Sql :: Get a list of tables and the primary key
Sql :: How to take sum of column with same id and different table in SQL?
Sql :: alter check constraint in mysql
Sql :: sql alias
Sql :: generate random data in mysql
Sql :: identify rows with 2 same column value and delete duplicate mysql