belick Posted September 22, 2008 Share Posted September 22, 2008 I have a field on database with this data: "'upholstery cleaning & maintenance tips" and I want to look it up with a string with out the "&" sign... something like SELECT * FROM TABLE WHERE Field1 LIKE '%upholstery cleaning maintenance tips%' Thanks Quote Link to comment Share on other sites More sharing options...
F1Fan Posted September 22, 2008 Share Posted September 22, 2008 Maybe this: SELECT * FROM TABLE WHERE Field1 LIKE '%upholstery cleaning%' AND Field1 LIKE '%maintenance tips%' Is that what you were looking for? Quote Link to comment Share on other sites More sharing options...
belick Posted September 23, 2008 Author Share Posted September 23, 2008 that can't work because I have a lot of different queries and its not matching because 1 or 2 characters... Quote Link to comment Share on other sites More sharing options...
F1Fan Posted September 23, 2008 Share Posted September 23, 2008 You can use ILIKE, which is case insensitive, but if you're wanting to look for something that's close, I'm not sure how to do that. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 29, 2008 Share Posted September 29, 2008 That's full-text searching... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.