[MerryDeer]

Hi,

How to format that querie i want to update by user name and jobid, but some specific jobs that job id not can by in row, so how to specific job what i want?

like

where name='anyname' AND jobid='1 10 5 8'

[SyS]

Sorry i cant understand what you said can please explain it better? i think you are talking about selecting rows having job is not null. If thats the case you can use WHERE clause with NOT NULL or <>NULL statements.

[MerryDeer]

No i want where job is for ex 3 id or 5 idor 6 id

[SyS]

use where jobid in(3,5,6)