Android Question SQLite Like

[Robert Valentino]

I have a SQLite DB that has a bunch of prefixes in it I want to see if the line I have matches one or more of the prefixes

Cannot figure out how to say something like this

"Select * for PrefixFile where <line> LIKE PrefixData%"     ' where PrefixData is a Field in the PrefixFile that I want to LIKE on

Can the SQLite Column be on the right side of this statement?
'

 

[aeric]

You mean the matching should starts with value in PrefixData column?

 

[aeric]

Data:

line	PrefixData
B4X IDEs consists of B4A, B4i, B4J and B4R.	B4X
B4A is an IDE to build Android apps.	Android
Android Studio is very complicated.	Android

SELECT * FROM PrefixFile WHERE line LIKE PrefixData||'%'

Results:

line	PrefixData
B4X IDEs consists of B4A, B4i, B4J and B4R.	B4X
Android Studio is very complicated.	Android

 

[Robert Valentino]

Found the error in my code thanks to Aeric. I wasn't putting the quotes around the % sign
Had this

$"select * for PrefixFile where ${line} LIKE PrefixData || %"$