Filtros en Tablas

Creating tables and queries

Filtros en Tablas

Postby EricRamirezRodriguez » Sat Feb 02, 2008 12:28 am

Que comando debo de usar para filtrar los registros que contengan una parte de la palabra en determinado campo?, es decir, el campo con el nombre Colonia tiene los siguientes registros: jardines de satelite, ciudad satelite, viveros del valle, valle dorado, bosque real. Que comando debo utilizar en la tabla para que al escribir una parte de la palabra de los registros, por ejemplo, sat, me muestre unicamente los registros que contengan sat, es decir, jardines de satelite, ciudad satelite

De antemano muchas gracias.
Eric Ramirez Rodriguez.
EricRamirezRodriguez
 
Posts: 3
Joined: Sun Dec 30, 2007 8:01 pm

Re: Filtros en Tablas

Postby DrewJensen » Sat Feb 02, 2008 12:38 am

Hi Eric,

First I should point out that this is an English language forum - there is an individual that has asked about the possibility of opening a forum in Espagnol - you might want to send an email to him to see how it is going , his user name here is Neggo

Meanwhile

You want to use a LIKE statement with wild cards

SELECT * FROM TABLE
WHERE FIELD LIKE %sat%
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
User avatar
DrewJensen
Volunteer
 
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 1 guest