sqldb

[ezra]

hi
i have a file with records, the records look like this
like,want,love,feel - this is one records , how can i found all the records that have the word feel in them ?
i want to work with sql commands.
thank's ezra

[DavidN]

For your SQL query, you would use:

SELECT * FROM mytable WHERE myfield LIKE "%feel%"

(Or something like that, anyway. I can never remember SQL syntax.)

The "LIKE" allows the use of wildcard characters in the search term, and the % characters represent any number of letter on either side of the "feel".

Now, after typing all that out, I've just realized that you meant only the ones that exactly match "feel". This is even simpler:

SELECT * FROM mytable WHERE myfield='feel'

[ezra]

thanks
i try it