not sure you can do this just with mysql, I think your gunna need to select
the html from the db then send it to something like perl or php and use a
regex parser on it.

-----Original Message-----
From: Bob Ramsey [mailto:[EMAIL PROTECTED] 
Sent: 03 October 2004 12:45
To: [EMAIL PROTECTED]
Subject: filed that does not contain text between symbols

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]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

  • ... Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
    • ... Paul DuBois
      • ... Bob Ramsey
        • ... Chris Blackwell
          • ... Bob Ramsey
        • ... Santino
          • ... Gerald Taylor
        • ... SGreen
          • ... Bob Ramsey
            • ... Michael Stassen
      • ... Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem

Reply via email to