>If you are looking for 'Advertising' in the column, >why not just put this in your query > >where SECTOR = 'Advertising'
Yes, but instead of 'Advertising' I could have 'Advertising,Media,Whatever' So I need to have a way of finding out whether SECTOR is contained in 'Advertising,Media,Whatever' instead of vice versa. rgds _________________________________________________________________ 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
