Baron,
Thank you for your answer. The information you refered me to is
very interesting and will take some time to study. However most of what
it appears to cover is getting the search data into a table, which is
already accomplished. Basically the query I am trying to come up with
would be something like:
SELECT
`ticket`.`Work Log`,
`server_list`.`application_name`,
FROM
`ticket`,`server_list`
Where `ticket`.`Work Log` like `server_list`.`application_name`
This is formatted like if I were searching for a single text string such
as '%access%' (i.e. Where `ticket`.`Work Log` like '%access%') but I
don't understand how to write the query to return values from within the
other table. I don't need anything especially fancy, I just need to
understand. The big hole in my understanding is that one table has a
single list, so the other is large text block which could contain words
within the single list. I just havent figured out how to deal with this
yet.
Again, I really appreciate your response previously, thank you.
Regards,
Craig
-----Original Message-----
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 12, 2007 1:17 PM
To: Weston, Craig (OFT)
Cc: mysql@lists.mysql.com
Subject: Re: Query against two data types
Hi,
If at all possible, normalizing the data is far and away the best
solution.
Failing that, you can use regular expressions
RLIKE REPLACE(col, ' ', '|')
or INSTR(....). Another solution is fulltext search, but it would have
many
limitations depending on what you really need to do. Otherwise, try the
approaches given here: http://www.sommarskog.se/arrays-in-sql.html
But prepare yourself for some deep thinking if you want to understand
how they
work, especially the one that works against a table of numbers; it's a
little
murky, though it is probably the best of the solutions.
Weston, Craig (OFT) wrote:
> Hello all. I have a query I am tring to implement and I can't wrap my
> mind around it somehow. Can anyone help?
>
>
>
> .
>
>
>
> I have two tables within a database.
>
>
>
> Within the first table, I have a blob field that basically has a large
> amount of text.
>
>
>
> Within the second table, I have a list of strings (in this case
> application names).
>
>
>
> Is there some way that I can search the blob for any occurrence of any
> of the strings? (returning the string name)?
>
>
>
> There could be more than 1 match.
>
>
>
> Any ideas?
>
>
>
> Thank you for any help you may offer.
>
> Craig
> --------------------------------------------------------
> This e-mail, including any attachments, may be confidential,
privileged or otherwise legally protected. It is intended only for the
addressee. If you received this e-mail in error or from someone who was
not authorized to send it to you, do not disseminate, copy or otherwise
use this e-mail or its attachments. Please notify the sender
immediately by reply e-mail and delete the e-mail from your system.
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
