07-19-2007
|
| Administrator
Join Date: Jun 2007
Posts: 3,729
BRL$: 31,913.65 Thanks: 0
Thanked 4 Times in 4 Posts
Rep Power: 403 | |  I want to search for a single word in a field on a SQL table...
Here is what I'm trying to do, I don't know if there is quite a command to do it though:I have a field on my SQL table called "Info" with a couple sentences in each row.I want to put together an SQL query that will allow me to select rows that have a certain word in the field "info", but I don't want it to find partial words.So if one of the rows had "I had a great day today" in the info field I want a statement that will find the row using the search term "today", but not the search term "day".I suppose I could modify the search term to be " today " and make sure the sentence has a space at the beginning and end of it, but there must be a better way?
To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.
| |
__________________
█ High Quality
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
█ Powerful
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
█
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
| | | |
