Click to See Complete Forum and Search --> : SQLite query match exact word in phrase


PeejAvery
June 18th, 2009, 04:49 PM
The following will return all occurrances of "word" even something like "password." However, I only want the exact word match. Any ideas?

SELECT * FROM paragraphs WHERE paragraph LIKE '%word%'

PeejAvery
June 18th, 2009, 08:02 PM
Well, in a rush, I just added a couple of OR statements for a comma, period, and exclamation mark.