How to concat columns in Android sqlite

Question

Can I concat two or more columns in Android sqlite ? eg select columna++ columnb as columnc from table

Femi · Accepted Answer · 2011-05-09 03:21:15Z

16

Try select columna || columnb as columnc from table.

answered May 9, 2011 at 3:21

Femi

64.8k8 gold badges120 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ERROR/AndroidRuntime(264): Caused by: java.lang.IllegalArgumentException: column 'TITLE || BEGIN as BLABLA' does not exist

Not sure why you are having problems:

Cursor mCursor = mDb.rawQuery("SELECT *, \""+ KEY_NAME + "\" || \""+KEY_DESC + "\" AS val FROM "+DATABASE_TABLE_LOGS + " ORDER BY " + order, null);

works for me. I can extract the val column from the resulting cursor. You might need to escape the columns as I did above (using double quotes).