Hi, I have a table which contains a column 'category'
'category' can be made up as records such as: christmas|birthday|easter easter|thanksgiving birthday|christmas|thanksgiving|easter etc ..... As you can see, items are delimited with a '|' in the fields. If I wish to select all records which contain 'christmas', what is the correct sql syntax please? (This should return records 1 and 3 from the example shown above) I've tried several approaches, but have failed so far. Thanks for any pointers. kind regards, Graham Nichols --------------------------------------------------------------------- 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