basic query question

Not sure if i am asking this the right way but -

Can anyone tell me what the symbol is for 'contains' instead of 'equals' ?.

i.e

SELECT * FROM datasearch WHERE email = '@'

I need to change this to

SELECT * FROM datasearch WHERE email CONTAINS '@'

"Mike" <me@privacy.net> wrote in
news:1261grak0kond78@corp.supernews.com:

> Not sure if i am asking this the right way but -
>
> Can anyone tell me what the symbol is for 'contains' instead of
> 'equals' ?.
>
> i.e
>
> SELECT * FROM datasearch WHERE email = '@'
>
> I need to change this to
>
> SELECT * FROM datasearch WHERE email CONTAINS '@'

SELECT * FROM datasearch WHERE email LIKE '%@%'

"Good Man" <heyho@letsgo.com> wrote in message
news:Xns97BE7FDDBB9C9sonicyouth@216.196.97.131...
> "Mike" <me@privacy.net> wrote in
> news:1261grak0kond78@corp.supernews.com:
>
>> Not sure if i am asking this the right way but -
>>
>> Can anyone tell me what the symbol is for 'contains' instead of
>> 'equals' ?.
>>
>> i.e
>>
>> SELECT * FROM datasearch WHERE email = '@'
>>
>> I need to change this to
>>
>> SELECT * FROM datasearch WHERE email CONTAINS '@'
>
> SELECT * FROM datasearch WHERE email LIKE '%@%'
>


thank you, i tried LIKE but was missing %


question. can you think of a query to show me the email field that has
content but not containing the @ symbol

ie. SELECT * FROM datasearch WHERE email = something but excluding @

"Mike" <me@privacy.net> wrote in
news:1261ijbo0v2m1ac@corp.supernews.com:

>>> SELECT * FROM datasearch WHERE email = '@'
>>>
>>> I need to change this to
>>>
>>> SELECT * FROM datasearch WHERE email CONTAINS '@'
>>
>> SELECT * FROM datasearch WHERE email LIKE '%@%'
>>
>
>
> thank you, i tried LIKE but was missing %
>
>
> question. can you think of a query to show me the email field that
> has content but not containing the @ symbol
>
> ie. SELECT * FROM datasearch WHERE email = something but excluding @

my guess (not tested) would be:

SELECT * FROM datasearch WHERE email NOT LIKE '%@%'

"Good Man" <heyho@letsgo.com> wrote in message
news:Xns97BE84974F998sonicyouth@216.196.97.131...
> "Mike" <me@privacy.net> wrote in
> news:1261ijbo0v2m1ac@corp.supernews.com:
>
>>>> SELECT * FROM datasearch WHERE email = '@'
>>>>
>>>> I need to change this to
>>>>
>>>> SELECT * FROM datasearch WHERE email CONTAINS '@'
>>>
>>> SELECT * FROM datasearch WHERE email LIKE '%@%'
>>>
>>
>>
>> thank you, i tried LIKE but was missing %
>>
>>
>> question. can you think of a query to show me the email field that
>> has content but not containing the @ symbol
>>
>> ie. SELECT * FROM datasearch WHERE email = something but excluding @
>
> my guess (not tested) would be:
>
> SELECT * FROM datasearch WHERE email NOT LIKE '%@%'
>

ok thx. that would show all the blank rows to though. i need to find a
way to show the rows with something entered but exclude the @ or exclude
both the empty and @.
its got me stumped

You need to add the bit about there being 'something' in the field -
so;

SELECT email1address FROM contacts WHERE email1address NOT LIKE '%@%'
AND email1address NOT LIKE '' ;

"strawberry" <zac.carey@gmail.com> wrote in message
news:1147195071.743560.88220@e56g2000cwe.googlegro ups.com...
> You need to add the bit about there being 'something' in the field -
> so;
>
> SELECT email1address FROM contacts WHERE email1address NOT LIKE '%@%'
> AND email1address NOT LIKE '' ;
>

thats the one thank you

On Tue, 9 May 2006 18:16:53 +0100, Mike wrote:
>
> "Good Man" <heyho@letsgo.com> wrote in message
> news:Xns97BE84974F998sonicyouth@216.196.97.131...
>> "Mike" <me@privacy.net> wrote in
>> news:1261ijbo0v2m1ac@corp.supernews.com:
>>
>>>>> SELECT * FROM datasearch WHERE email = '@'
>>>>>
>>>>> I need to change this to
>>>>>
>>>>> SELECT * FROM datasearch WHERE email CONTAINS '@'
>>>>
>>>> SELECT * FROM datasearch WHERE email LIKE '%@%'
>>>>
>>>
>>>
>>> thank you, i tried LIKE but was missing %
>>>
>>>
>>> question. can you think of a query to show me the email field that
>>> has content but not containing the @ symbol
>>>
>>> ie. SELECT * FROM datasearch WHERE email = something but excluding @
>>
>> my guess (not tested) would be:
>>
>> SELECT * FROM datasearch WHERE email NOT LIKE '%@%'
>>
>
> ok thx. that would show all the blank rows to though. i need to find a
> way to show the rows with something entered but exclude the @ or exclude
> both the empty and @.
> its got me stumped

SELECT * FROM datasearch WHERE email NOT LIKE '%@%'
AND email != ' ';

--
_ o
|/)