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

Reply via email to