I am trying to give MySQL a string and then compare it to a column.
For example, say I have the string: "helloworld", and I have a
table with one column ("keyword"), and three records: "low", "324", "kda".
I want to select the records that are found in the string (in this
case, I want it to return "low").
I have tried the like comparison:
select * from [table] where ([string] like [keyword])
but that only works if the string is exactly the same as the keyword.
In this case, the string is longer. Normally, I would use %'s,
but how do I do that with a column name?
select * from [table] where ([string] like %[keyword]$)
does not work.
Am I way off track here? Is there a simple way to do this that I
have somehow overlooked? Is there a complex way to do this that
will at least get the job done? Thanks.
-Antonio
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
