CodeIgniter How to use WHERE clause and OR clause

Question

I am using the following code to select from a MySQL database with a Code Igniter webapp    query    this- gt db- gt get where  mytable  array  id   gt 10      This works great  But I want to write the following MySQL statement using the CI library   SELECT   FROM  mytable  WHERE  id   10  OR  field   value    Any ideas  Thanks

User · Answer

Active record method or where is to be used    this- gt db- gt select      - gt from  table name   - gt where  first    first  - gt or where  second    second

User · Answer

You can use this     this- gt db- gt select        this- gt db- gt from  mytable     this- gt db- gt where name  Joe     bind   array  boss    active     this- gt db- gt where in  status    bind

User · Answer

What worked for me       where              this- gt db- gt like  ust title   query data  search            - gt or like  usr f name   query data  search            - gt or like  usr l name   query data  search                where      ust title like      query data  search                  where      or usr f name like      query data  search                  where     or usr l name like      query data  search                   this- gt db- gt where  where       datas    this- gt db- gt join TBL USERS   AS usr   ust user id usr id               - gt where in  ust id    blog list               - gt select  ust   usr f name as f name usr email as email usr avatar as avatar  usr sex as sex               - gt get where TBL GURU BLOG   AS ust                     ust deleted at        gt   NULL                   ust status        gt   1                     I have to do this to create a query like this    SELECT  ust      usr   f name  as  f name    usr   email  as  email    usr   avatar  as  avatar    usr   sex  as  sex  FROM  blog  AS  ust  JOIN  users  AS  usr  ON  ust   user id   usr   id  WHERE   ust   title  LIKE   mer   ESCAPE     OR   usr   f name  LIKE   lok   ESCAPE     OR   usr   l name  LIKE   mer   ESCAPE      AND  ust   id  IN  36    37    38   AND  ust   deleted at  IS NULL AND  ust   status    1

User · Answer

You can use or where   for that - example from the CI docs    this- gt db- gt where  name       name     this- gt db- gt or where  id  gt     id        Produces  WHERE name     Joe  OR id  gt  50

User · Answer

where    name  Joe  AND status  boss  OR status  active      this- gt db- gt where  where

User · Answer

where    name  Joe  AND status  boss  OR status  active      this- gt db- gt where  where     Though I am 3 4 of a month late  you still execute the following after your where clauses are defined     this- gt db- gt get  tbl name

[mysql] CodeIgniter: How to use WHERE clause and OR clause

Examples related to mysql

Examples related to select

Examples related to codeigniter

Examples related to where-clause