search

wkim / h2database

Automatically exported from code.google.com/p/h2database
0 stars 0 forks source link

SELECT IF(v.value LIKE 'a', 1, 0) doesn't work in H2 DB #593

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
The following query fails on H2 DB on MySQL mode, although it runs on on a 
MySQL instance:

SELECT IF(v.value LIKE 'a', 1, 0) AS `value`
FROM values v

My I know if there is an IF function equivalent for H2 DB ?

Thanks

Original issue reported on code.google.com by ghe...@gmail.com on 9 Dec 2014 at 8:18

GoogleCodeExporter commented 8 years ago 
For questions, use the Google Group

Original comment by thomas.t...@gmail.com on 10 Dec 2014 at 10:13