concat
concatenate two columns
SELECT concat ( 'my' , 'sql' )
coalesce
return first non null column
SELECT coalesce ( col1 , col2 )
interval
Use "interval" to create a month range
<date> between '20070701' and '20070701' + interval 1 month - interval 1 day
replace
replace all instances of old with new
SELECT REPLACE( col, old, new )
locate
locate string
SELECT locate( search, string, start )
substring
get substring
SELECT substring( col, start, length )
REFERRERS
MySqlDesignQuery
There are no comments on this page. [Add comment]