lto:st...@astroh.org]
> Sent: June 3, 2010 11:55 AM
> To: Steven Staples
> Cc: 'MySql'
> Subject: Re: Help needed on query on multiple tables
>
> Thanks! That did it perfectly!
>
> Michael
>
>
> On Jun 3, 2010, at 11:45 AM, Steven Staples wrote:
>
> &
aybe something like this could give you a
> starting point?
>
> Steven Staples
>
>
>> -Original Message-
>> From: Michael Stroh [mailto:st...@astroh.org]
>> Sent: June 3, 2010 11:24 AM
>> To: MySql
>> Subject: Help needed on query on multiple
nt: June 3, 2010 11:24 AM
> To: MySql
> Subject: Help needed on query on multiple tables
>
> Hi everyone. I'm trying to create a certain MySQL query but I'm not sure
> how to do it. Here is a stripped down version of the result I'm aiming
for.
> I'm pretty new
Hi everyone. I'm trying to create a certain MySQL query but I'm not sure how to
do it. Here is a stripped down version of the result I'm aiming for. I'm pretty
new to queries that act on multiple tables, so apologize if this is a very
stupid question.
I have one table (data) that has two column
. The single-quotes are required.
Note this will always do a full table scan, so if your table is big, it will
be slow.
..chris
- Original Message -
From: "thor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 4:22 AM
Subject: Help need
Hi,
> Now I need a query which will take the values from column
> 'query', treat them as patterns for matching and return
> row(s) which match the given string 'blahblah'. In this
> example, the matched data is obviously in second row.
> (bla% matches blahblah)
> Do I make any sense?
I have a table like this one:
+-+---+---+
| uid | username | query |
+-+---+---+
| 1 | someuser | %qu1% |
| 2 | anotheru | bla% |
+-+---+---+
I get a string from external source, let's say the string is 'blahblah'.
Now I need a query which
