PDA

View Full Version : merge two columns into one

BubikolRamios
03-21-2008, 10:02 PM
Need to merge col GB and SLO

Data:

GB SLO

degre stopinja
foot NULL
ampere amper

the result of query should be, in sence whenewer there is no translation to SLO, take GB:

stopinja
foot
amper

How to do that ?
Fumigator
03-22-2008, 01:04 AM
Look into ifnull() (http://dev.mysql.com/doc/refman/4.1/en/control-flow-functions.html#function_ifnull).