MESSAGE
| DATE | 2003-07-25 |
| FROM | joev_nylxs@pipeline.com
|
| SUBJECT | Subject: [hangout] Re: Regular Expression Help
|
This is what I was able to work out:
SELECT name FROM table WHERE name RLIKE 'word1|word2|word3'
this seems to allow the regexp to return word1 or word2 or word3 which
will work for now.
Joe
Bruce Ingalls wrote:
> "and/or" is an improper boolean expression. Note further, that regexes
> under /standard/ SQL are old
> and limited, although mysql may have extensions, and ISO SQL 2000(?)
> offers an improvement.
>
> For "word" followed by a single char,
> select column from table, where column like word_;
> Substitute "column" and "table" with your particular values. SQL is not
> case sensitive.
>
> Joe Villari wrote:
>
>>
>> I'm trying to write a search for a mysql table. I need to search for
>> either word1 and/or word2 and/or word3 etc. I see I can use regexp
>> but I'm having a hard time getting the one to say word1 and/or word2
>> and/or word3 ...
>>
>> Any ideas or direction?
>>
>> Thanks
>> Joe
>>
>> ____________________________
>> NYLXS: New Yorker Free Software Users Scene
>> Fair Use -
>> because it's either fair use or useless....
>> NYLXS is a trademark of NYLXS, Inc
>
>
>
>
____________________________
NYLXS: New Yorker Free Software Users Scene
Fair Use -
because it's either fair use or useless....
NYLXS is a trademark of NYLXS, Inc
|
|
