Top "Case" questions

SWITCH with LIKE inside SELECT query in MySQL

I have this Tags table CREATE TABLE IF NOT EXISTS `Tags` ( `id_tag` int(10) unsigned NOT NULL auto_increment, `tag` …

sql mysql case switch-statement sql-like

How to get multiple columns in a single SQL CASE statement?

I'm trying to get multiple columns(insuredcode, insuredname in this case) from a single CASE statement. The following query has …

sql case informix

using CASE in T-SQL in the where clause?

Im trying to use case to vary the value im checking in a where clause but I'm getting the error: …

tsql case where-clause

MySQL SELECT CASE WHEN something THEN returning null

Table who wid--name-------father---mother 1----Daisy------David----Liza 2----Jenny------Joe------Judy 3----Meggy------Mike-----Manuela 4----Sarah------Joe------Judy 5----Chelsea----Bill-----Hillary 6----Cindy------David----Liza 7----Kelly------Joe------Judy Table ages aid---whoid---age 1-----1--------0 2-----2--------0 3-----3-------14 4-----4…

mysql select sql-order-by case

How to do a case with multiple conditions?

In the 1 month experience I've had with any programming language, I've assumed that switch case conditions would accept anything in …

java boolean switch-statement case

Perl Switch Statement

Is there any way to run a block of code if none of the case blocks were matched? For instance: …

perl switch-statement case conditional-statements

Nested CASE statements in MySQL

My first time working with CASE Logic in SQL statements. Everything works if I remove the CASE statements, so the …

mysql case

MySQL using Sum and Case

I'm trying to create a GridView with ASP.NET connecting to a MySQL database. The data appears like below. BusinessUnit …

mysql sql sum case

How can I have lowercase routes in ASP.NET MVC?

How can I have lowercase, plus underscore if possible, routes in ASP.NET MVC? So that I would have /dinners/…

asp.net-mvc url routes case

Case-insensitive PowerShell replacement

I have the following PowerShell script: $RegExplorer = Get-ItemProperty -Path HKLM:\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters $NullSessionPipes = "$($RegExplorer.NullSessionPipes)" $NullSessionPipes $NullSessionPipes = $…

powershell replace case