Re: NOT LIKE

2005-01-11 Thread Jigal van Hemert
> How do I exclude any records where the path column is > '/realtors/Kokomo/%'? You're too funny... you gave the answer on the subject line of your e-mail :-) Read http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html Scroll down past the section on LIKE and

NOT LIKE

2005-01-11 Thread Ed Curtis
I've been searching the docs and can't find examples how to do what I need to do. I need to exclude some records from my SELECT statement results but it appears I can't use (=, != or LIKE) for it. What I have is a result set having a column name 'path'. I need to exclude any record reulting in