Maybe you better do something like: SELECT * FROM woorden WHERE % woord % LIKE <string>
-----Oorspronkelijk bericht----- Van: Mevershosting.nl [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 18 maart 2005 16:11 Aan: mysql@lists.mysql.com Onderwerp: Help with LIKE Dear list, I need some help on this, I have a DB with one table The table (woorden) contains 1 field (woord) varchar(255) What i would like to be able to do is. SELECT * FROM woorden WHERE <string> LIKE % woord % so i need the fields in the table which fit into the string i submit. example: The string is: housewife and the result i would like to have is: house wife I hope somebody can help me. Greetings, Richard Mevers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]