Оптимизация строки запроса

Discussion in 'PHP' started by serg-php, 10 Dec 2010.

Thread Status:
Not open for further replies.
  1. serg-php

    serg-php Elder - Старейшина

    Joined:
    28 Jan 2008
    Messages:
    313
    Likes Received:
    9
    Reputations:
    0
    Есть

    $sql = 'WHERE ('.get_adv_search_query().')'.'AND ((region_id=29)OR(region_id=57)OR(region_id=58))'.hwFilterGetSQL('l.');


    Есть ли Варианты сократить

    (region_id=29)OR(region_id=57)OR(region_id=58) ???
     
    #1 serg-php, 10 Dec 2010
  2. GRRRL Power

    GRRRL Power Elder - Старейшина

    Joined:
    13 Jul 2010
    Messages:
    823
    Likes Received:
    185
    Reputations:
    84
    and region_id in (29, 57, 58)
     
    #2 GRRRL Power, 10 Dec 2010
  3. serg-php

    serg-php Elder - Старейшина

    Joined:
    28 Jan 2008
    Messages:
    313
    Likes Received:
    9
    Reputations:
    0
    GRRRL Power,

    попробую!

    Спасибо!
     
    #3 serg-php, 10 Dec 2010
  4. Gifts

    Gifts Green member

    Joined:
    25 Apr 2008
    Messages:
    2,494
    Likes Received:
    807
    Reputations:
    614
    /thread62769.html

    // Закрыто
     
    _________________________
    #4 Gifts, 10 Dec 2010
(You must log in or sign up to post here.)
Thread Status:
Not open for further replies.