Hi I want to have some query like
Select
case column1
when column2 like '%Test%' then column 3
else 0
end
FROM myTable
in column2 there are varchars stored. Can someone help me with this?
-
2there's not much logic written in your example.mauris– mauris2009-11-27 09:41:39 +00:00Commented Nov 27, 2009 at 9:41
-
2You should try and expalin the logic you wish to achieve.Adriaan Stander– Adriaan Stander2009-11-27 09:46:32 +00:00Commented Nov 27, 2009 at 9:46
Add a comment
|
2 Answers
That doesn't make much sense. Why do you do a case on column1 but completely ignore that value afterwards? Did you just copy and (w)paste that into your query?
Anyways, this is what I would expect to work in any of the ordinary RDBMS':
case
when colum2 like ...then
3
else
0
end as abc
However, the only thing I know of mySQL is that it usually does everything different than your average Joe RDMS would do them.
1 Comment
Sebastian Müller
this was simply an example but your answer fits my needs, thank you
Do you mean something like...
Select column3 from myTable where column2 like '%Test%'
union all
select 0 from myTable where column2 not like '%Test%'
Note that the "not like" operator can be slow
Comments
