Topic: Example SQLITE Search By Array Script Of String
I try find function regexp in sqlite have not
but i try create script create script sql for search value
Can input multiple value in one line for search by " "
IF MySQL USE regexp
where column regexp '123|456'
Screen Short
Open Code
procedure Form1_Edit2_OnChange (Sender: TObject);
var
i : Integer ;
original_string : String;
arr_string : Array Of String ;
begin
Form1.Memo2.Clear ;
original_string := Trim(Form1.Edit2.Text);
Form1.Memo2.Lines.add('SELECT * FROM city WHERE 1 = 1');
arr_string := SplitString(original_string,' ');
For i := 0 To Length(arr_string) -1
Do
Begin
Form1.Memo2.Lines.add('AND tip LIKE "%'+arr_string[i]+'%"')
End;
Form1.TableGrid1.dbSQL := Form1.Memo2.Text ;
Form1.TableGrid1.dbSQLExecute;
Form1.TableGrid1.BestFitColumns(bfboth);
end;
begin
end.
Easy For Beginner Student For Me