Hello, How is REGEXP used? I have looked at the manual. If I have the following values in my db table: Id. .... regdate 00 ca. 1900 01 1910 02 ca. 1700-tallet 03 1550-tallet 04 1600-1700 ....... and the query parameters: 190, 155, 170, I want the result of the search to be:
ca. 1900 1900-tallet 1550-tallet 1600-1700 I have tried $sql = "SELECT ..... FROM ................... WHERE .....= ...... AND regdate REGEXP '(190|155|170)' "; What is wrong here? I am new starter in the world of mysql. Thanks in advance. OO --------------------------------------------------------------------- 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