Professional Web Applications Themes

WHERE & AS - MySQL

Hi, Is it possible to create a field name and then use it in a where statement? SELECT CONCAT(`Product Index`.`Product_Headings`,' ',COALESCE(`Product Index`.`Sub_Product_Headings`,'')) AS `product_name` FROM `product index` WHERE product_name LIKE '%Alar%' This statement errors with Unknown column 'product_name' in 'where clause' Not sure if it can be done. Thanks A...

  1. #1

    Default WHERE & AS

    Hi,

    Is it possible to create a field name and then use it in a where
    statement?

    SELECT
    CONCAT(`Product Index`.`Product_Headings`,' ',COALESCE(`Product
    Index`.`Sub_Product_Headings`,''))
    AS `product_name`
    FROM `product index`
    WHERE product_name LIKE '%Alar%'

    This statement errors with Unknown column 'product_name' in 'where
    clause'

    Not sure if it can be done.

    Thanks

    A

    UKuser Guest

  2. #2

    Default Re: WHERE & AS


    "UKuser" <co.uk> wrote in message
    news:googlegroups.com... 

    Yup (or so I am led to believe)

    SELECT
    CONCAT(`Product Index`.`Product_Headings`,'
    ',COALESCE(`ProductIndex`.`Sub_Product_Headings`,' '))
    AS `product_name`
    FROM `product index`
    HAVING product_name LIKE '%Alar%'

    Hope it works...



    Sean Guest

  3. #3

    Default Re: WHERE & AS

    On 5 Apr, 13:56, "Sean" <sean.anderson[nospam]oakleafgroup.biz>
    wrote: 






    >
    > Yup (or so I am led to believe)
    >
    > SELECT
    > CONCAT(`Product Index`.`Product_Headings`,'
    > ',COALESCE(`ProductIndex`.`Sub_Product_Headings`,' '))
    > AS `product_name`
    > FROM `product index`
    > HAVING product_name LIKE '%Alar%'
    >
    > Hope it works...[/ref]

    Superb - thanks indeed!

    A

    UKuser Guest

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139