tim's journal

A nice recursive query

update keywords set
word3 = IF ( locate( ' ', rest) , left( rest, locate( ' ', rest)-1 ) , rest),
rest = IF ( locate( ' ', rest) , substring( rest from locate( ' ', rest)+1 ) , '' )