your example only needs a "like" not a regex.
not having your schema i'll show a loose example:
select id, flilepath from movies where filepath like "%MyMovie.%";
Bharath Booshan L wrote:
Hello list,
I have to perform a search something similar to this
ID FilePath
1 /Volumes/Backup/MyMovies/MyMovie.mp4
2 /Volumes/Backup/MyMovies/Hello.mp4
3 /Volumes/Tiger/MyMovie.mov
Search for file name MyMovie should retrieve
ID FilePath
1 /Volumes/Backup/MyMovies/MyMovie.mp4
3 /Volumes/Tiger/MyMovie.mov
To simplify, I am searching for a file name from a collection of absolute
file paths.
How can I achieve this in SQLite?
Is there anyways I can use regular expression in a query to perform string
matching.
Thanks in advance,
Bharath
-----------------------------------------------
Robosoft Technologies - Come home to Technology
Disclaimer: This email may contain confidential material. If you were not an
intended recipient, please notify the sender and delete all copies. Emails to
and from our network may be logged and monitored. This email and its
attachments are scanned for virus by our scanners and are believed to be safe.
However, no warranty is given that this email is free of malicious content or
virus.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------