mysql querie - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql querie (/showthread.php?tid=626860)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql querie (/showthread.php?tid=626860)
mysql querie - MerryDeer - 21.01.2017
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'
Re: mysql querie - SyS - 21.01.2017
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.
Re: mysql querie - MerryDeer - 21.01.2017
No i want where job is for ex 3 id or 5 idor 6 id
Re: mysql querie - SyS - 21.01.2017
use where jobid in(3,5,6)