Additions:
==convert==
use convert to convert character sets
select CONVERT( _utf8 'asdfasdfasdf' using latin1 )
use convert to convert character sets
select CONVERT( _utf8 'asdfasdfasdf' using latin1 )
Additions:
==conv==
convert from one base to another (hex2dec)
SELECT
conv(mid(hexcolour,1,2),16,10) as r,
conv(mid(hexcolour,3,2),16,10) as g,
conv(mid(hexcolour,5,2),16,10) as b
FROM
hexcolours
select <date> between '20070701' and '20070701' + interval 1 month - interval 1 day
convert from one base to another (hex2dec)
SELECT
conv(mid(hexcolour,1,2),16,10) as r,
conv(mid(hexcolour,3,2),16,10) as g,
conv(mid(hexcolour,5,2),16,10) as b
FROM
hexcolours
select <date> between '20070701' and '20070701' + interval 1 month - interval 1 day
Deletions:
Additions:
==interval==
Use "interval" to create a month range
<date> between '20070701' and '20070701' + interval 1 month - interval 1 day
Use "interval" to create a month range
<date> between '20070701' and '20070701' + interval 1 month - interval 1 day
Additions:
==replace==
==locate==
locate string
select locate( search, string, start )
==substring==
get substring
select substring( col, start, length )
==locate==
locate string
select locate( search, string, start )
==substring==
get substring
select substring( col, start, length )
Deletions:
Additions:
==REPLACE==
replace all instances of old with new
select replace( col, old, new )
----
REFERRERS
{{backlinks}}
replace all instances of old with new
select replace( col, old, new )
----
REFERRERS
{{backlinks}}
