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.
Filtros en Tablas
- DrewJensen
- Volunteer
- Posts: 1734
- Joined: Sat Oct 06, 2007 9:01 pm
- Location: Cumberland, MD - USA
Re: Filtros en Tablas
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%
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
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04