Hello, I have just imported from a textfile database to mysql.. In the database table, I have the following values: Id. date 00 ca. 1900 01 1900 02 1900-tallet => meaning 1900 - 1999 03 1950-tallet => meaning 1950 - 1959 04 1500-1600 .......
I want to use standard mysql pattern matching to do the query. A query parameter can be 1400-2000 and the search result will be: ca. 1900 1900 1900-tallet 1950-tallet 1500-1600 When the query parameter is 1900-1949, the result will be: ca. 1900 1900 1900-tallet When the query parameter is 1950 - 2000, the result will be: 1900-tallet 1950-tallet I have tried using IN, REGEXP, but it did no work. I need help. 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
