Hi,
Trying to get to grips with regexp but really want to 1st get a simple
expression working with mysql.
SELECT Sequence, Message, id FROM $sqlTable WHERE Sequence
REGEXP(\"^$filterValue;\")
The above works for finding matched values, where the number = to
$filterValue is in in the 1st part.
But I need to do one for the 2nd part and 3rd and 4th etc, where each
value is seperated by ;
So I may want to search for 6 in the 2nd part, like below:-
1;6
10;6
100;6
1;6;1
10;6;10
100;6;100
I need a regexp that would get all of the above but not any value other
than 6 in the 2nd part.
Then say I was looking for 6 in the 3rd part:-
1;6;6
10;1;6
100;10;6
100;100;6
1;100;6
10;100;6
Any help would be appreciated.
M.
--
Work:- postmasterAThinwick.demon.co.uk WEB:- http://www.hinwick.demon.co.uk
Work:- mworsdallATshaftesburysoc.org.uk REPLACE AT with @
Home:- hinwickATworsdall.demon.co.uk WEB:- http://www.wizdom.org.uk
Shadow:- webmasterATshadow.org.uk WEB:- http://www.shadow.org.uk
---------------------------------------------------------------------
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