Hello folks, sorry to bother you. You must admit I take 6 months or more to
ask questions:):)
Using the first part of this query works fine to return data by searching
the multiple concatenated columns, very happy with that.
SELECT * FROM sitelist
WHERE
On 25 Apr 2010, at 2:44pm, flakpit wrote:
Using the first part of this query works fine to return data by searching
the multiple concatenated columns, very happy with that.
SELECT * FROM sitelist
WHERE
sitename||username||password||serialnum||misc1||misc2||misc3||misc4||misc5||notes
LIKE
Just add your AND and ORDER by clauses on after the '%wik%'. But I don't
know why there's a '7' at the end of your original line. I don't think it
does anything. Perhaps a typo when you made the post ?
SELECT * FROM sitelist
WHERE
flakpit wrote:
SELECT * FROM sitelist
WHERE
sitename||username||password||serialnum||misc1||misc2||misc3||misc4||misc5||notes
LIKE '%wik%'
AND category='Bundled Software'
AND owner='Gary'
ORDER BY sitename
Hello Simon, that's what I tried first (yes, the '7' was a typo, sorry) and
it
Igor Tandetnik wrote:
Define didn't work. What results did this query return, and how do these
results differ from your expectations?
it is not giving me any results at the moment.
Well, do you actually have any records that match all the conditions? Show
a sample of your data; in