[RESOLVED] search query with not working!

spiritssight

Hello there,

I am trying to figure out how to script a process:

here is how I was doing it:

$query = " SELECT *
	          FROM irs_rawdata 
                  WHERE 
                               PNO LIKE '%blind%' OR
                               PNO LIKE '%deaf%'  OR
                               PNO LIKE '%eye%'   OR
                               xxx LIKE '%%' OR xxx LIKE ...
	";

my thought was to have a file called accept_criterias.lst this file would have a list of two cols this could be a db table instead if that would be better.
col one col two
PNO blind
PNO deaf
xx1 g41
xx1 g42

my goal of this is to look at the records in the table irs_rawdata one at a time, if it matches it would be moved to the table irs_query

I will do the move by using insert / select query then do a delete of the record that is in the irs_rawdata table

if it does not match then it delete the record

So any how any ideas on how I can do this?

Sincerely,
Christopher

rsmith

Group the WHERE conditions:

$query = "SELECT * FROM irs_rawdata WHERE (PNO like '%blind%' OR PNO LIKE '%deaf%' OR PNO LIKE '%eye%')";

spiritssight

so would that be like doing:

WHERE PNO LIKE '%eye%'
WHERE AC LIKE '%g41%'
WHERE SN_SNL LIKE '%NFB%'

if this is not what you had in mind could you point me to a example or show me one

Thanks
Christopher

Kudose

WHERE PNO LIKE '%eye%' OR AC LIKE '%g41%' OR SN_SNL LIKE '%NFB'

WHERE PNO LIKE '%eye%' AND AC LIKE '%g41%' AND SN_SNL LIKE '%NFB'

WHERE (PNO LIKE '%eye%' AND AC LIKE '%g41%') OR SN_SNL LIKE '%NFB'

http://dev.mysql.com/doc/refman/5.0/en/where-optimizations.html