Search Issues

[andrewbeck]

I am pretty new to MySQL, so I don't know if I'm explaining this right. Please excuse me! :-)

I have an image bank with a search feature. The sql document code looks like this:

INSERT INTO novoCatalog VALUES (0,'M3877','',1,'imgCatalog/abstractModern3/M3877.jpg',' watercolor yellow orange red','small',62,3877,0);

(The red text is of course the search terms that define when the specific image will show up.)

My problem is that when you type say "water" in the search bar, the results return all these unrelated images because "watercolor" has the word "water" in it. How do I keep that from happening? Is there exceptions I can input into the code or something?

[james438]

select * from novoCatalog where column REGEXP 'water([[:blank:]]|$)'

That should do the trick. the above will match water followed by a space or water that is at the end of a string.