Alternate for regexp in sqlite

[dsba]

Hi,

I was trying to get the count of id that starts from 712 where id is of 6 digit number. But this fails and always print 0 whereas I tried on db sqlite browser, then it prints 80 whose command mentioned

SELECT COUNT(*) AS RowCnt from testTable where id regexp '712'

Is there any other alternative to perform same operation from qt, if so kindly help me know?

Thanks in advance

[Christian Ehrlicher]

@dsba said in Alternate for regexp in sqlite:

Is there any other alternative to perform same operation from qt

I don't see why it should not work with Qt. Please show us your code.

[jsulm]

@dsba Why don't you use https://www.w3schools.com/sql/sql_like.asp ?
Should it not be like:

SELECT COUNT(*) AS RowCnt from testTable where id regexp '712.*'

?

[dsba]

Hi
Thanks for the reply
I could do using 'like' statement of sqlite
SELECT COUNT(*) AS RowCnt from testTable where id like '712%'
this resolved the issue