Hello. Is it possible to create a column in sql like

if je.name = "JE1309" then 'Right' else 'Wrong'

? Actually I tried mysql query CASE WHEN but it didn't work.

@Boris Yasen Can you show us your CASE statement?

@Clay Roper SELECT gas.frequency, gas.name, case when gas.name = 'TESTING3' then 'TESTING' else 'Except' end as 'custom' FROM GeneralAllocationSchedule as gas

Those quotes around your column alias might be breaking it. Are you getting an invalid or unsupported search error?

yes you are right

remove the

'

from around

custom

thank you. I appreciate your help

Sure, hope you get where you need to go!