For example, I have a string "Administration,Advertising,Direction,Media,Research" and I want to see whether a SECTOR field in a row is contained in the above string.
so that I can select rows which contain only "Advertising" in their SECTOR field.. sort of like a reverse LIKE, whether a field is contained in a string I supply to MySQL. Is there a way to do it without splitting the above string and checking for each sector specifically? _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php