[sqlite] finding records with an underscore using like

LIKE '%_%'; Can anyone suggest a proper statement that escapes the underscore, so the above will work as intended? Thank you! Joe Noon

Re: [sqlite] Import CSV in sqlite3?

> > You can use a system call to execute a command like the following; > > > > sqlite3 -separator , test.db ".import test.csv sometable" > > > > That is exactly what I needed! Thanks a ton. > > Joe Noon > My issue now is that the csv may or

Re: [sqlite] Import CSV in sqlite3?

> You can use a system call to execute a command like the following; > > sqlite3 -separator , test.db ".import test.csv sometable" > That is exactly what I needed! Thanks a ton. Joe Noon

[sqlite] Import CSV in sqlite3?

to use the .import functionality through code? If its possible please enlighten me. Any helpful suggestions would be very much appreciated! Joe Noon