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 you
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, sor
>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
sitename||username||password||serialnum||misc1||misc2||misc
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
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
sitename||username||password||serialnum||
5 matches
Mail list logo
