You will need the RLIKE comparator. http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html http://dev.mysql.com/doc/mysql/en/Regexp.html
I haven't tested this but this is pretty close to what you will need WHERE page_body RLIKE '<img *>' and page_body not RLIKE '<img *alt=*>' you will have to experiment a bit to get the correct expression. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Bob Ramsey <[EMAIL PROTECTED]> wrote on 10/03/2004 07:45:22 AM: > Hi, > > I have some web pages in a database and I want to check to make sure > that all of the images have alt tags in them. So what I need to do is > ask something like this in psuedocode: > > select page_name from web_pages where page_body does not contain 'alt=' > between '<img' and '>'; > > But I just can't figure out the right syntax. Any ideas? > > Thanks, > > bob > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >