How to say it

[manalnor]

Hello friends,

 

Can you help me as always.

 

let say we have database table (id,user,name,code)

 

and i'm gonna say MYSQL

 

$qry="select * from table order by id desc";

 

Now how to say

 

select from table where (user) is not empty and (code) is not  'something'

 

i did tried this

 

$qry="select * from table where user IS NOT NULL AND code IS NOT LIKE 'something' order by id desc";

 

but didn't work so how to say it and where i could learn such mysql commands cause i know it only in php like x == y and x != y ..ect

 

thanks

[Maq]

If you want to exclude an exact value then use:

AND code != 'something'

 

EDIT: Also, I'm not sure what your default value is (assume it's NULL) but you may want to check for an empty string as well.

AND user != ''

[manalnor]

thank you so much i did understood how it works

both user != '' and code != 'something' works perfect 

 

shokran شكراً = thanks 

[Maq]

shokran شكراً = thanks 

Heh, I actually knew that, my buddy is Lebanese   You're welcome.