Re: Help with LIKE

2005-03-18 Thread Jeremy Cole
Hi Mevers, SELECT * FROM woorden WHERE LIKE % woord % It's not going to be efficient (at all) but you can do: SELECT * FROM woorden WHERE "foo" LIKE CONCAT('%', woord, '%') Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives: http:

RE: Help with LIKE

2005-03-18 Thread Reinhart Viane
Maybe you better do something like: SELECT * FROM woorden WHERE % woord % LIKE -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 hav