Advertisement
lucindio

Select com variáveis

Jul 26th, 2020
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.33 KB | None | 0 0
  1. SELECT
  2.       calldate,src,dst,dstchannel,(billsec/60),disposition,uniqueid
  3. FROM cdr
  4. WHERE billsec >=4
  5. AND convert(calldate, date) BETWEEN '$ano_i-$mes_i-$diba_i' and '$ano_f-$mes_f-$dia_f'
  6. AND src = $src
  7. AND dstchannel REGEXP '(^.*[SIP]\/[a-zA-Z]{3})'
  8. AND  dst REGEXP '^.{3}[5-9]{1}.*' OR '^.{1}9[0-9]{8}'
  9. ORDER BY calldate;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement