Hi everybody, I'm new on the list, this is my first topic.

I was wondering if it's possible to check for a string ( a url, name, etc ) matchs with a list of values into a table.

Eg.: table myvalues(int id, varchar value);

imagine I have a few rows in this tables and I have the string "my foo string for test".

I would like to check if the string match with some row in the table myvalues, for ex. a row like (1, 'foo') should match.

Thanks for your attention.

Leandro Costa wrote:
Of course it is.

select count(id) from myvalues where value like '%my foo string for
test%' would get you something sane.

e.g. on a table that records the whois results of people accessing one
of my sites..

select count(id) from ipdata where whois like'%microsoft%';
+-----------+

tells me that 289 different IP addresses that belong to Microsoft
registered domains (hotmail mostly) have accessed the site.



> Thanks for your attention.

Natural Philosopher, thanks for you answer, but this I know how to do .

What I want is, I have the string: "my foo string for test".

I have the table myvalues like:


1, bar
2, aaa
3, foo
4, bbb
5, ccc

I want to do a query that tells my that the row 3 ( 3,fool ) matchs to my string: "my foo string for test"


I found the solution, it's like:

select * from myvalues where "my foo string for test" like concat('%',value,'%');

in this example it will output:

3, fool.


Thanks for your attention.

If someone can think some better way to do the same, I would be glad.

On Fri, 2 Sep 2011 08:41:25 -0700 (PDT), Leandro Costa wrote:
Full-text searches will do this. See section 11.9 and especially 11.9.2
in the manual

--
_ o
> /)