I have a parts database and one of the fields is called description. I want to do a select based on keywords in the description field. For example a description, as stored in the database, may be 1/2\" Med Blue Laminate. Notice that the double quotes is escaped. If I want to get all parts that have 1/2" in their description what would the select be.
I have tried
SELECT * FROM parts WHERE description LIKE '%1/2"%'
and
SELECT * FROM parts WHERE description LIKE '%1/2\"%'
but I get an empty set. What should the query be?
I have tried
SELECT * FROM parts WHERE description LIKE '%1/2"%'
and
SELECT * FROM parts WHERE description LIKE '%1/2\"%'
but I get an empty set. What should the query be?