Select from where field not equal to Mysql Php

Question

I m just wondering what kind of mysql command i could execute in php that would select all items from a certain table where columna is not equal to x and columnb is not equal to x  Something like  select something from table where columna does not equal x and columnb does not equal x  Any ideas

User · Answer

Or can also insert the statement inside bracket   SELECT   FROM tablename WHERE NOT  columnA    x

User · Answer

You can use like  NOT columnA    x    Or  columnA     x    Or  columnA  lt  gt   x    And like Jeffly Bake s query  for including null values  you don t have to write like   NOT columnA    x  OR columnA IS NULL    You can make it simple by  Not columnA  lt   gt   x     lt    is the Null Safe equal to Operator  which includes results from even null values

User · Answer

The key is the sql query  which you will set up as a string    sqlquery    SELECT field1  field2 FROM table WHERE NOT columnA    x  AND NOT columbB    y      Note that there are a lot of ways to specify NOT  Another one that works just as well is    sqlquery    SELECT field1  field2 FROM table WHERE columnA     x  AND columbB     y      Here is a full example of how to use it    link   mysql connect  dbHost  dbUser  dbPass  or die  Unable to connect to database    mysql select db   dbName   or die  Unable to select database  dbName     sqlquery    SELECT field1  field2 FROM table WHERE NOT columnA    x  AND NOT columbB    y     result mysql query  sqlquery    while   row   mysql fetch assoc  result      do stuff     You can do whatever you would like within the above while loop  Access each field of the table as an element of the  row array which means that  row  field1   will give you the value for field1 on the current row  and  row  field2   will give you the value for field2   Note that if the column s  could have NULL values  those will not be found using either of the above syntaxes  You will need to add clauses to include NULL values    sqlquery    SELECT field1  field2 FROM table WHERE  NOT columnA    x  OR columnA IS NULL  AND  NOT columbB    y  OR columnB IS NULL

User · Answer

select   from table where fiels1 NOT LIKE  x  AND field2 NOT LIKE  y      this work in case insensitive manner

User · Answer

You can use also   select   from tablename where column1   a  and column2   b

User · Answer

sqlquery    SELECT field1  field2 FROM table WHERE columnA  lt  gt   x  AND columbB  lt  gt   y      I d suggest using the diamond operator   lt    in favor of    as the first one is valid SQL and the second one is a MySQL addition

[php] Select from where field not equal to Mysql Php

Examples related to php

Examples related to mysql

Examples related to sql

Examples related to database

Examples related to select