Hello,
having this data
abcd efgh hilmne
abcd efgh hilmne
abcd efgh hilmne
abcd efgh hilmno
abcd efgh hilmno
abcd efgh hilmno
abcd efgh hilmna
abcd efgh hilmna
...
...
how can I build a query that extracts all records with hilmne?
Thanks
Where clause using part of a string
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Where clause using part of a string
Buongiorno Alessio,
is one line one database field in one record in your example data?
Or a "set" of (several) fields in one record?
In any case you will be need to use: LIKE %...
Something like this if one line is one field in your example:
...
SELECT * from YOURTABLE WHERE YOUR_FIELD LIKE '%hilmne%'
...
Check this for more info:
http://www.w3schools.com/sql/default.asp
Best
Klaus
is one line one database field in one record in your example data?
Or a "set" of (several) fields in one record?
In any case you will be need to use: LIKE %...
Something like this if one line is one field in your example:
...
SELECT * from YOURTABLE WHERE YOUR_FIELD LIKE '%hilmne%'
...
Check this for more info:
http://www.w3schools.com/sql/default.asp
Best
Klaus
-
- Posts: 90
- Joined: Sun Feb 15, 2015 2:51 pm
Re: Where clause using part of a string
Guten tag Klaus
you're right, I did not specify that the data on which I intend to run the query are found every line in the same field of the database. I try with% like.
Thank you
you're right, I did not specify that the data on which I intend to run the query are found every line in the same field of the database. I try with% like.
Thank you