nested loop or join help please

[paulmo]

I need help getting this query started, either nested loop or join.

 

On one table, $word (which is a text string from form) gets matched to column 'good'; if match, $word gets matched to column 'keyword'; match on 'keyword' echoes same row id in 'echo_good' column to user.

 

if no match on 'good', match against column 'bad' etc.

 

if no match on good or bad but match on 'keyword', echo message to user to elaborate on keyword match.

 

thanks in advance to someone who can get me off the ground on this one.

[paulmo]

Someone who is good at queries please respond on this one.

 

Thanks

[fenway]

Match how?

[paulmo]

like this:

 

On one table, $word (which is a text string from form) gets matched to column 'good'; if match, $word gets matched to column 'keyword'; match on 'keyword' echoes same row id in 'echo_good' column to user.

 

if no match on 'good', match against column 'bad' etc.

 

if no match on good or bad but match on 'keyword', echo message to user to elaborate on keyword match.

 

[fenway]

Well, if you're doing a dumb string match, then sure, you can see if substring matches are true or false for each column.

[paulmo]

not sure how "dumb" figures but yes I'm looking at boolean true or falses for each column now.

[fenway]

Then use LOCATE().