Re: I need help constructing a search thingy using % & _ in LIKE

2001-07-27 Thread tj marlin
yes, but then you wouldn't learn. if you don't want to buy Dubois' book, try appendix J of the mySql reference manual, available for free from the mysql site. At 06:06 PM 7/26/01 +0100, you wrote: >In message <[EMAIL PROTECTED]>, tj marlin ><[EMAIL PROTECTED]> writes >>I think it is time for

Re: I need help constructing a search thingy using % & _ in LIKE

2001-07-26 Thread Mark Worsdall
In message <[EMAIL PROTECTED]>, tj marlin <[EMAIL PROTECTED]> writes >I think it is time for you to learn about regular expressions; page 520 >ff of Dubois. >(sql, mysql, database - to get past the filter) > any chance of an example or full syntax? M. -- Work:- postmasterAThinwick.demon.co

I need help constructing a search thingy using % & _ in LIKE

2001-07-25 Thread tj marlin
I think it is time for you to learn about regular expressions; page 520 ff of Dubois. (sql, mysql, database - to get past the filter) At 01:14 AM 7/26/01 +0100, you wrote: >Hi all, > >I have a problem, I have some VARCHAR data in a column called Sequence >looking like this:- > >5;6 >12;6

Re: I need help constructing a search thingy using % & _ in LIKE

2001-07-25 Thread tj marlin
I think it is time for you to learn about regular expressions; page 520 ff of Dubois. (sql, mysql, database - to get past the filter) At 01:14 AM 7/26/01 +0100, you wrote: >Hi all, > >I have a problem, I have some VARCHAR data in a column called Sequence >looking like this:- > >5;6 >12;6 >120;

I need help constructing a search thingy using % & _ in LIKE

2001-07-25 Thread Mark Worsdall
Hi all, I have a problem, I have some VARCHAR data in a column called Sequence looking like this:- 5;6 12;6 120;6 5;6;1 12;6;12 120;6;105 So there could be anything from 2 to n numbers seperated by ; Each number could be 1 to 3 digits long (eg 5 12 or 121). I have tried various searches like