Here is another user with the same problem http://forums.pcworld.co.nz/archive/index.php/t-34536.html
Maybe his explanation is better :) Quoting John thegimper <[EMAIL PROTECTED]>: > SELECT * FROM tbl WHERE item REGEXP 'SEARCHSTRING' > > Database holds: > SAMSUNG IDE 40GB 7200RPM > > Search for > SAMSUNG IDE 7200RPM = 0 RESULTS > SAMSUNG 40GB 7200RPM = 0 RESULTS > SAMSUNG +40GB +7200RPM = 0 RESULTS > SAMSUNG IDE 40GB = 1 RESULT > > How do i need to change the SEARCHSTRING to use AND for each word? > SAMSUNG 40GB should return one result. > > > > > > > > > ------------------------------------------------- > FREE E-MAIL IN 1 MINUTE! > - [EMAIL PROTECTED] - http://www.pc.nu > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > ------------------------------------------------- FREE E-MAIL IN 1 MINUTE! - [EMAIL PROTECTED] - http://www.pc.nu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
