List:General Discussion« Previous MessageNext Message »
From:Terence Date:August 19 2002 7:08am
Subject:where clause structures
View as plain text  
try this:

select....where WHATEVER LIKE 'whatever%'

notice the '%' at the end not the beginning...hope this is what you
wanted...

lekker dag verder boet.

----- Original Message -----
From: "Chris Knipe" <savage@stripped>
To: <mysql@stripped>
Sent: Sunday, August 18, 2002 5:54 AM
Subject: Re: where clause structures


EEK

Tables structures :P

mysql> describe CompanyDetails;
+-------------------+-------------------------------+------+-----+---------+
----------------+
| Field             | Type                          | Null | Key | Default |
Extra          |
+-------------------+-------------------------------+------+-----+---------+
----------------+
| CompanyID         | tinyint(4) unsigned           |      | PRI | NULL    |
auto_increment |
| CompanyActive     | enum('1','0')                 |      | MUL | 0       |
|
| CompanySuspended  | enum('0','1','2','3','4','5') |      | MUL | 0       |
|
<snip>

mysql> describe CompanyDNSZones;
+--------------+------------------------------------------------------------
---------------+------+-----+-------------+----------------+
| Field        | Type
| Null | Key | Default     | Extra          |
+--------------+------------------------------------------------------------
---------------+------+-----+-------------+----------------+
| ZoneID       | int(11)
|      | PRI | NULL        | auto_increment |
| CompanyID    | smallint(6)
|      | MUL | 0           |                |
| ZoneName     | varchar(250)
|      | UNI |             |                |
| ZoneServices |
set('HasMail','HasMailingList','HasBackupMail','IsMegaDNS','IsSecondary') |
| MUL |             |                |




----- Original Message -----
From: "Chris Knipe" <savage@stripped>
To: <mysql@stripped>
Sent: Saturday, August 17, 2002 11:44 PM
Subject: where clause structures


> Lo everyone,
>
> I seem to be having a problem with the structuring of my query - more
> specifically, with the WHERE clause...
>
> mysql> SELECT ZoneName
>     ->   FROM CompanyDNSZones
>     ->   LEFT JOIN CompanyDetails ON
> CompanyDetails.CompanyID=CompanyDNSZones.CompanyID
>     ->   WHERE CompanyDetails.CompanySuspended='0' AND
>     ->         CompanyDNSZones.ZoneName='megalan.co.za' AND
>     ->         CompanyDNSZones.ZoneServices LIKE '%HasMail%' OR
>     ->         CompanyDNSZones.ZoneServices LIKE '%HasMailingList%';
> +---------------------+
> | ZoneName            |
> +---------------------+
> | megalan.co.za       |
> | lists.megalan.co.za |
> +---------------------+
> 2 rows in set (0.01 sec)
>
> How do I get it to only return the item specified in the WHERE clause?
>
> I explictly tell MySQL in my where clause to only return results where
> CompanyDNSZones.ZoneName='megalan.co.za', so where does it fall out
> returning lists.megalan.co.za as well?
>
> --
> me
>
> PS: Just for interest takes, can LEFT / RIGHT / a combination of LEFT &
> RIGHT joins be used to cross-reference three or more tables, or is it
> limited to 2 tables only?
>
>
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread117457@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-savage=savage.za.org@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


---------------------------------------------------------------------
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 <mysql-thread117458@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-terencel=sunway.edu.my@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
where clause structuresChris Knipe18 Aug
  • Re: where clause structuresChris Knipe18 Aug
  • where clause structuresTerence19 Aug
  • Re: where clause structuresAleksandar Bradaric19 Aug
    • Re: where clause structuresKeith C. Ivey19 Aug