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

Possible duplicate: http://stackoverflow.com/q/3568779/2291 – Jon Adams Oct 31 '12 at 20:49 — Jon Adams, Oct 31 '12 at 20:49

score 16 · Accepted Answer · answered May 09 '11 at 03:21

16

Try select columna || columnb as columnc from table.

answered May 09 '11 at 03:21

Femi

ERROR/AndroidRuntime(264): Caused by: java.lang.IllegalArgumentException: column 'TITLE || BEGIN as BLABLA' does not exist – czesław May 09 '11 at 11:51
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). – Femi May 09 '11 at 14:23

1 Answers1