mySQL - Select Field Based On Second Field Value?

Sorry about the thread title, it probably doesn't make much sense. I was just wondering if it is possible to select FieldA or FieldB depending on the value of FieldC... all fields are in the same table.

Here is some pseudo code...

Code:

SELECT( `preview` IF `has-preview` ELSE `text` ) AS `output`

So, if `has-preview` is true then `preview` is returned otherwise `text` is returned.

www.si-robertson.com

Nutrox

No problem, I've worked it out.

Code:

SELECT CASE WHEN `has-preview` THEN `preview` ELSE `text` END AS `output`

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Ultrashock Forums > Development > Server Side • mySQL - Select Field Based On Second Field Value?	Member Blogs

	Nutrox 1 Blog Entries 13 Creative Assets	4 Weeks Ago #2
	No problem, I've worked it out. Code: SELECT CASE WHEN `has-preview` THEN `preview` ELSE `text` END AS `output`