EmilianoRoldanR

Agregar 0 a los celulares

Mar 5th, 2021
2,004
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /* VER TODOS LOS TELEFONOS DE LOS CLIENTES QUE SON CELULARES */
  2.  
  3. SELECT idcliente, nombre, direccion, telefono1
  4. FROM clientes
  5. WHERE telefono1 LIKE '91%' OR
  6.       telefono1 LIKE '92%' OR
  7.       telefono1 LIKE '93%' OR
  8.       telefono1 LIKE '94%' OR
  9.       telefono1 LIKE '95%' OR
  10.       telefono1 LIKE '96%' OR
  11.       telefono1 LIKE '97%' OR
  12.       telefono1 LIKE '98%' OR
  13.       telefono1 LIKE '99%'
  14. ORDER BY telefono1 ASC
  15.  
  16. /* AGREGAR 0 A LOS CELULARE */
  17.  
  18. UPDATE clientes SET telefono1 = CONCAT ('0', telefono1 )
  19. WHERE telefono1 LIKE '91%' OR
  20.       telefono1 LIKE '92%' OR
  21.       telefono1 LIKE '93%' OR
  22.       telefono1 LIKE '94%' OR
  23.       telefono1 LIKE '95%' OR
  24.       telefono1 LIKE '96%' OR
  25.       telefono1 LIKE '97%' OR
  26.       telefono1 LIKE '98%' OR
  27.       telefono1 LIKE '99%'
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×