G
G
gsdev992019-10-31 14:58:30
SQLite
gsdev99, 2019-10-31 14:58:30

How to replace CONCAT in sqlite?

Hello. I have a MySQL query:

SELECT * FROM people WHERE CONCAT (pbfirstName, pblastName, pbcity) LIKE "%со%" OR CONCAT (pbfirstName, pblastName, pbcity) LIKE "%fi%"

Please tell me how can I rewrite it for sqlite. As far as I understand CONCAT in sqlite, it is ||. But I didn't get a valid one.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question