Select Distinct

SELECT state FROM address WHERE addressType = ‘P’ AND endDate = ‘0000-00-00’; State SC SC SC MA Sometimes the returned results of your select statement may contain duplicate information. The example above demonstrates what happens when querying the address table without the DISTINCT keyword. The address table may contain several […]

Concatenation

A concatenation is the combining of two or more columns, expressions, or literal strings to display combined data in one column.┬áThe MySQL function for concatenation is CONCAT. For example: CONCAT( expression_1, ‘ ‘, expression_2 ) where expression_1 and expression_2 are either column names, expressions, or literal strings separated by a┬ádelimiter. […]