Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* VER TODOS LOS TELEFONOS DE LOS CLIENTES QUE SON CELULARES */
- SELECT idcliente, nombre, direccion, telefono1
- FROM clientes
- WHERE telefono1 LIKE '91%' OR
- telefono1 LIKE '92%' OR
- telefono1 LIKE '93%' OR
- telefono1 LIKE '94%' OR
- telefono1 LIKE '95%' OR
- telefono1 LIKE '96%' OR
- telefono1 LIKE '97%' OR
- telefono1 LIKE '98%' OR
- telefono1 LIKE '99%'
- ORDER BY telefono1 ASC
- /* AGREGAR 0 A LOS CELULARE */
- UPDATE clientes SET telefono1 = CONCAT ('0', telefono1 )
- WHERE telefono1 LIKE '91%' OR
- telefono1 LIKE '92%' OR
- telefono1 LIKE '93%' OR
- telefono1 LIKE '94%' OR
- telefono1 LIKE '95%' OR
- telefono1 LIKE '96%' OR
- telefono1 LIKE '97%' OR
- telefono1 LIKE '98%' OR
- telefono1 LIKE '99%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement