how to use LIKE with column name with SQLite

Asked Sep 13 '20 at 17:19

Active Sep 14 '20 at 10:28

Viewed 33 times

I have a SQLite table with columns like these: id, name_1, name_2, name_nick, phone, email

and I am looking for a way to search in all columns which begins with name_.

Like LIKE but for the column names.

I find a lot for MySQL etc, but just this one for SQLite:
https://stackoverflow.com/a/60814644/8110291
But it is for a query with two tables and i need only one.

The solution should be pure SQL, because I am just starting to deal with this language and I want to get to know the possibilities.

edited Sep 14 '20 at 10:28

droopsnoot

asked Sep 13 '20 at 17:19

kolja

1

If it's only searching three columns, why not just use OR? – droopsnoot Sep 13 '20 at 17:26
No, there are mor columns, 'name_' was just an example. – kolja Sep 13 '20 at 17:36

0 Answers0